Error: Invalid Column Name “ExcelErrorName”

Product:  BizInsight
Applies to:  MAS 500
Article Type:  Error 

Summary:
When drilling down on a BizInsight formula, the pivot table fails to build and the following error message will appear:

Invalid Column Name “ExcelErrorName”
Problems Obtaining Data

Details:
This error is caused by using the drill down option on a worksheet that contains an ampersand (&) in the sheet name. Microsoft Excel will look for a linked worksheet in this situation and cause the drill down to fail. For example, if a sheet is named Sales&Orders, Excel will look for a linked worksheet named Orders and the pivot table will not be created.

Resolution/Workaround:
To resolve this issue, remove the ‘&’ contained in the sheet name.

If the provided Resolution/Workaround does not resolve your issues, please contact BizNet Software Support for further assistance.