Error: "#NAME" or "#NAME?" displays in Excel when running a Report Designer Add-In report in Sage 100 Intelligence.

Description

Possible Workaround:

  1. In Excel, select a cell displaying the “#NAME?# error
  2. Click the fx button
  3. Click Ok
  4. Correct value amount will now display in cell

Note: Repeat steps above for every cell that is displaying the error

Also be sure that all BI Folders in C:\Program Files (x86)\Common Files have Full Control Permissions for Users. If there has been a MS Office Security update, it’s possible that permissions were reset. Always check to be sure permissions are granted by right clicking the folder and selecting Security.

Resolution

Install Report Designer Add-in:

  1. Log into Sage Support Portal and click link to download Report Designer Add-in (see Article ID 45993
  2. Close Excel and Sage 100 Intelligence
  3. Verify UAC (User Account Control) is set to Never Notify
  4. The Report Designer Add-In installation file MUST be saved to the local drive where it is going to be installed (ex. Desktop)
  5. Right click on the Report Designer Add-in v1.0Setup.exe file and click Run as Administrator
  6. Follow prompts to proceed through installation wizard.

If error still persists;

  1. Go to Excel, File, Options and click Add-Ins

For Microsoft Excel:

  1. Verify that Analysis ToolPak is NOT in the Active Application Add-Ins section
  2. Verify that Solver Add-In is NOT in the Active Application Add-Ins section

If either Add-In is on the list, do the following:

  1. Highlight the Item then at the bottom of screen Manage should already be on Excel Add-Ins
  2. Click on Go button
  3. Uncheck those Add-Ins in that list and click on OK
  4. Verify that those Add-Ins now show in the Inactive Application Add-In section

For Sage 100 Intelligence:

  1. Verify the following appear in the Active Application Add-ins section:
  2. Report Designer Add-in 1.0.0 / Type = Excel Add-in
  3. Report Designer Add-In 1.0.0 (Custom Task Pane Helper) / Type = COM Add-in

If either Add-In is not on the list, scroll to the bottom of the screen to the Manage section and do the following:

  1. Select Excel Add-ins from the Manage drop down list and click Go
  2. If the Report Designer Add-in 1.0 is listed, check the box.
  3. If the Report Designer Add-in 1.0 is not listed, click Browse and browse to: C:\Program Files\Common Files\BIExcelFunctions\32bit\Sage.BI.ExcelFunctions.xll **Note: If on a 64-bit machine go to C:\Program Files (x86)\Common Files\BIExcelFunctions\32bit\Sage.BI.ExcelFunctions.xll and click Ok
  4. Note: when the Report Designer Add-in 1.0.0 is selected the Report Designer Add-In 1.0.0 (Custom Task Pane Helper) should be dynamically selected. If it is not listed, click COM Add-ins from the Manage drop down and click Go and If Report Designer Add-In 1.0.0 (Custom Task Pane Helper) is on the list check the box
  5. Verify that the Sage Intelligence Add-Ins now show in the Active Application Add-In section
  6. It may be necessary to exit Excel and Reopen to see all changes and Add-Ins in their correct location

If Add-Ins are still are not on the listed in Excel, please do the following ordered steps to reinstall the Report Designer Add-in:

  1. In Report Manager, rename the Report Designer Add-in and Report Designer Add-in Consolidation folders
  2. Using Add and Remove Programs, select Sage 100 ERP Intelligence Report Designer Add-in and click Uninstall
  3. Reinstall the Sage 100 ERP Intelligence Report Designer Add-in.

Important Reminders for Installing:

  • If installing on Windows 7 or higher, right click on the .exe file and select Run as Administrator.
  • Sage support recommends you disable User Account Control (UAC). For more information, please see: How to Disable User Account Control
  • Sage Intelligence AND Excel must both be closed when installing Report Designer Add-In. And the user must have Local Administrator Permissions.

If error still persists and the Report Designer Add-in is listed in Excel Add-ins, close Excel and Report Manager

  1. Open Excel
  2. Open Report Manager, generate report with Excel already opened

Note: If error is occurs when opening a distributed Report Designer Add-in type of report, please see Article ID 26054: ARCHIVE: Download Sage Intelligence Distribution Patch for Sage 100 ERP to install the Sage Intelligence Distribution Patch on the local machine that is generating the report.