Difference between revisions of "XLCubed Excel Edition Troubleshooting"

(added calculated set error)
(Error when editing calculated members based on calculated sets)
Line 77: Line 77:
 
  Please check the details and try again.
 
  Please check the details and try again.
  
You may receive this error when using a named set in a calculated member.
+
You may receive this error when using a named set in a calculated member created on a non-Measures hierarchy.
  
 
For example (based on Adventure Works):
 
For example (based on Adventure Works):

Revision as of 10:56, 18 October 2013

Installation Troubleshooting

  • Details of prerequisites can be found here.

Could not access network location \Hewlett-Packard\\.

When installing XLCubed, you get the above error message. This is because of a faulty InstallLocation registry entry, found in these two places:

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\
HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\

You can either back up, then remove it manually, or follow the instructions listed in this article.

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:

Error while processing XLCubed.dna

When you open XLCubed, you get the following error message:

There was an error during processing of C:\Program Files (x86)\XLCubed Ltd\XLCubed\XLCubed.dna:
There is an error in XML document (0, 0).
The type initializer for 'System.Xml.Serialization.XmlSerializationReader' threw an exception.

This error can be caused by problems with one of several configuration files:

  • XLCubed.dna, XLCubed64.dna, XLCubed.xll.config or XLCubed64.xll.config, all found in the XLCubed installation folder (usually C:\Program Files (x86)\XLCubed Ltd\XLCubed)
  • Excel.exe.config, found in the Excel installation folder (usually C:\Program Files (x86)\Microsoft Office\Office15 or similar)
  • machine.config, found in the Microsoft.NET configuration folder (usually C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config and C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config)

The problems can be caused by several underlying issues:

  • The files do not exist (except for XLCubed.xll.config and Excel.exe.config, which are not necessary)
  • The files exist, but are protected and not accessible by Excel while it is loading
  • The files exist, but are corrupted

In particular, installation of some IBM Client Access providers can cause problems with the machine.config file. See this IBM support article for details.

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 (.xls). It is 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 is not 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 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.

Miscellaneous Issues

Error when editing calculated members based on calculated sets

You may receive this error:

The selected calculation could not be executed:
The 'NamedSetName' named set cannot be created because a set with the same name already exists.
Please check the details and try again.

You may receive this error when using a named set in a calculated member created on a non-Measures hierarchy.

For example (based on Adventure Works):

Named Set 'MySet' 
[Geography].[Geography].[Country].members
Calculated Member 'MyMember' 
Aggregate([MySet])

Editing the above results in an error. In order to resolve this, use the following MDX instead:

Named Set 'MySet' 
[Geography].[Geography].[Country].members
Calculated Member 'MyMember' 
Aggregate([Geography].[MySet])

In order to successfully create this once the error has been triggered, you will also have to rename the named set.

Further Help