Error: "#NAME" or "#NAME?" displays in Excel when running a Report Designer Add-In report in Sage 100 Intelligence.
Description
Possible Workaround:
- In Excel, select a cell displaying the “#NAME?# error
- Click the fx button
- Click Ok
- 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:
- Log into Sage Support Portal and click link to download Report Designer Add-in (see Article ID 45993
- Close Excel and Sage 100 Intelligence
- Verify UAC (User Account Control) is set to Never Notify
- The Report Designer Add-In installation file MUST be saved to the local drive where it is going to be installed (ex. Desktop)
- Right click on the Report Designer Add-in v1.0Setup.exe file and click Run as Administrator
- Follow prompts to proceed through installation wizard.
If error still persists;
- Go to Excel, File, Options and click Add-Ins
For Microsoft Excel:
- Verify that Analysis ToolPak is NOT in the Active Application Add-Ins section
- 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:
- Highlight the Item then at the bottom of screen Manage should already be on Excel Add-Ins
- Click on Go button
- Uncheck those Add-Ins in that list and click on OK
- Verify that those Add-Ins now show in the Inactive Application Add-In section
For Sage 100 Intelligence:
- Verify the following appear in the Active Application Add-ins section:
- Report Designer Add-in 1.0.0 / Type = Excel Add-in
- 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:
- Select Excel Add-ins from the Manage drop down list and click Go
- If the Report Designer Add-in 1.0 is listed, check the box.
- 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
- 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
- Verify that the Sage Intelligence Add-Ins now show in the Active Application Add-In section
- 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:
- In Report Manager, rename the Report Designer Add-in and Report Designer Add-in Consolidation folders
- Using Add and Remove Programs, select Sage 100 ERP Intelligence Report Designer Add-in and click Uninstall
- 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
- Open Excel
- 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.