Review and troubleshoot Slicer issues.
Cannot insert object error when inserting a Dimension Slicer
This error can be caused by a workbook being in protected mode. It may have the message, Unable to create specified ActiveX control. Please try to unprotect the workbook and insert the slicer.
If this doesn't help, this error is often caused by some of the Anaplan XL assemblies not being correctly registered. To re-register them, you must run the command below as an elevated administrator, using the path where Anaplan XL is installed:
"C:\Program Files (x86)\Anaplan\Anaplan XL Reporting\XLCubed.Excel.Installer.Utility.exe" /regctls
In previous versions, the /regctls switch wasn't available. In this case, use this instead, again using an administrator account:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\Anaplan\Anaplan XL Reporting\XLCubed.Excel.UserInterface.dll" C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\Anaplan\Anaplan XL Reporting\XLCubed.Excel.UserInterface.dll"
If these commands don't work, you may need to check the Excel Trust Center Settings to make sure that ActiveX controls are allowed with only a few limits. You also need to make sure that all the prerequisites are installed.
Can't exit design mode because Control 'ExcelDimensionSlicer1' can not be created error during normal operation
This error is caused by some corruption in your saved workbook when saving as Excel 97-2003 format (.xls). It's caused by a limitation of the .xls file format and can occur from time to time when using slicers. To fix the corruption, save the workbook as the more modern .xlsx file format instead. If this isn't available to you, the workbook can be temporarily fixed by:
- Save the file as .xlsx
- Close Excel
- Open the .xlsx workbook and resave as .xls
If you are using Microsoft Excel 2003, and are unable to save as .xlsx, you may need to install the Microsoft Office Compatibility Pack, which should enable you to save as the newer .xlsx format. Alternatively, for some workbooks you may be able to save as the XML Spreadsheet (.xml) type instead.
Slicers do not open when clicked
Slicers don't respond when being clicked, instead causing some of the Excel ribbons to become greyed out. This problem is experienced in some configurations, and can be fixed by turning on Optimize for compatibility in Excel. Navigate to Excel