XLCubed Excel Edition Troubleshooting

Revision as of 09:46, 27 February 2013 by Antonio.remedios (talk | contribs) (When I try to create a Grid Chart, no chart types are listed, and I cannot press OK to insert it.)

Installation Troubleshooting

  • Details of prerequisites can be found here.

XLCubed Ribbon or menu doesn't appear

Could not load file or assembly

When you perform certain actions, you get this error message:

Could not load file or assembly 'office, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.
(Exception from HRESULT: 0x80131040)

Download and install the following packages:

Grid Troubleshooting

When I try to create a Grid Chart, no chart types are listed, and I cannot press OK to insert it.

Your formats file may be missing or corrupted. Please back it up, then copy a new version from the XLCubed installation folder. Typical locations are:

Installation version 
C:\Program Files\XLCubed Ltd\XLCubed\FormatSheet.xls and FormatSheet.xlsx
User's customised version 
C:\Users\username\AppData\Roaming\XLCubed Ltd\XLCubed Excel Edition

Slicer Troubleshooting

You receive a Cannot insert object error when inserting a Dimension Slicer

This error is caused by some of the XLCubed assemblies not being correctly registered. To re-register them, you must run the following command as an elevated administrator:

 "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.Installer.Utility.exe" /regctls

In version 6.1 and prior 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\XLCubed Ltd\XLCubed\XLCubed.Excel.UserInterface.dll"
 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.UserInterface.dll"

You receive a 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 ({Code|.xls}}). To fix the corruption:

  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 allow 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.

Publishing Troubleshooting

  • Detailed information can be found here.

Further Help