Difference between revisions of "XLCubed Excel Edition Troubleshooting"

(Added grid charts problem)
Line 1: Line 1:
=Installation Troubleshooting=
+
==Installation Troubleshooting==
 
* Details of prerequisites can be found [[XLCubed Excel Edition Prerequisites|here]].
 
* Details of prerequisites can be found [[XLCubed Excel Edition Prerequisites|here]].
  
==XLCubed Ribbon or menu doesn't appear==
+
===XLCubed Ribbon or menu doesn't appear===
 
* See the [[Enable Ribbon Other Options]] article for help.
 
* See the [[Enable Ribbon Other Options]] article for help.
  
==Could not load file or assembly==
+
===Could not load file or assembly===
 
When you perform certain actions, you get this error message:
 
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'
 
  Could not load file or assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
Line 16: Line 16:
  
  
=Grid Troubleshooting=
+
==Grid Troubleshooting==
==When I try to create a Grid Chart, no chart types are listed, and I cannot press OK to insert it.==
+
===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:
 
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}}
 
;Installation version :{{Code|C:\Program Files\XLCubed Ltd\XLCubed\FormatSheet.xls}} and {{Code|FormatSheet.xlsx}}
Line 23: Line 23:
  
  
=Slicer Troubleshooting=
+
==Slicer Troubleshooting==
==You receive a 'Cannot insert object' error when inserting a [[Dimension Slicers|Dimension Slicer]]==
+
===You receive a 'Cannot insert object' error when inserting a [[Dimension Slicers|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:
 
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:
  
Line 35: Line 35:
  
  
=Publishing Troubleshooting=
+
==Publishing Troubleshooting==
 
* Detailed information can be found [[Publishing Troubleshooting|here]].
 
* Detailed information can be found [[Publishing Troubleshooting|here]].
  
  
=Further Help=
+
==Further Help==
 
* The XLCubed support team can be contacted at [mailto:support@xlcubed.com support@xlcubed.com].
 
* The XLCubed support team can be contacted at [mailto:support@xlcubed.com support@xlcubed.com].
  
 
[[Category:Troubleshooting]]
 
[[Category:Troubleshooting]]
 
[[Category:Main Page/Troubleshooting]]
 
[[Category:Main Page/Troubleshooting]]

Revision as of 11:40, 30 August 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