Difference between revisions of "XLCubed Excel Edition Troubleshooting"

(Installation Troubleshooting)
(Added grid charts problem)
Line 14: Line 14:
 
* [http://www.xlcubed.com/setup/o2007pia.msi Office 2007 Primary Interop Assemblies]
 
* [http://www.xlcubed.com/setup/o2007pia.msi Office 2007 Primary Interop Assemblies]
 
* [http://www.xlcubed.com/setup/o2010pia.msi Office 2010 Primary Interop Assemblies]
 
* [http://www.xlcubed.com/setup/o2010pia.msi Office 2010 Primary Interop Assemblies]
 +
 +
 +
=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, then copy a new version from the XLCubed installation folder. Typical locations are:
 +
;Installation version :{{Code|C:\Program Files\XLCubed Ltd\XLCubed\FormatSheet.xls}} and {{Code|FormatSheet.xlsx}}
 +
;User's customised version :{{Code|C:\Users\username\AppData\Roaming\XLCubed Ltd\XLCubed Excel Edition}}
 +
  
 
=Slicer Troubleshooting=
 
=Slicer Troubleshooting=
Line 25: Line 33:
 
{{Code|C:\Windows\Microsoft.NET\Framework\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.UserInterface.dll"}}
 
{{Code|C:\Windows\Microsoft.NET\Framework\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.UserInterface.dll"}}
 
{{Code|C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.UserInterface.dll"}}
 
{{Code|C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe /tlb /codebase "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.UserInterface.dll"}}
 +
  
 
=Publishing Troubleshooting=
 
=Publishing Troubleshooting=
 
* Detailed information can be found [[Publishing Troubleshooting|here]].
 
* Detailed information can be found [[Publishing Troubleshooting|here]].
 +
  
 
=Further Help=
 
=Further Help=

Revision as of 15:35, 5 July 2012

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=12.0.0.0, 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, 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"


Publishing Troubleshooting

  • Detailed information can be found here.


Further Help