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 minimal restrictions: Prompt me before enabling all controls with minimal restrictions. 

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 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 a more modern .xlsx file format instead. If this isn't available to you, the workbook can be temporarily fixed by:

  1. Save the file as .xlsx.
  2. Close Excel.
  3. 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 workbooks, you may be able to save as the XML Spreadsheet (.xml) type instead.

Slicers don't open when clicked

Slicers don't respond when being clicked, instead causing the Excel ribbons to become grayed out. This problem is experienced in configurations and can be fixed by turning on Optimize for compatibility in Excel. 

  1. Navigate to Excel.
  2. Select Options from the File menu.
  3. Choose Optimize for compatibility from the General tab.