Error: #NAME?

Product:  BizInsight
Applies to:  EAS
Article Type:  Error 

Summary:
When executing a BizInsight function in Excel, the user can receive this message:

#Name?

Details:
A #Name? error usually occurs when the BizInsight’s dll (Excel Add-in) is not installed, an incorrect function name has been specified, or the spreadsheet is opened in non-design mode.

#NAME? can also occur if the wrong Office version was selected during installation. For example, Office2000 was chosen instead of Office XP or Higher. This error message will also appear:

‘C:\Program Files\BizNet Software\BizExceleratorSunGard\SunGardEASFunctions.xla’ could not be found. Check the spelling of the file name, and verify that the file location is correct.

A #NAME error can also occur if the Office version being used is Office 2007 or 2010 and the file extension is .xlsx but the file was originally a .xls file format.  In this circumstance, Excel adds a non-existent path in front of the function name of the first function in the workbook. 

Resolution/Workaround:
To resolve this issue, check the following:

1. Make sure the function name is typed correctly.

2. Check to see if the BizInsight dll is installed.

For Excel 2003
Click the Tools tab in Excel. Select Add-Ins and look for BizExcelerator. It should be checked. If it is not there, click on the automation tab under the Add-Ins menu. Select “BizNetXLSungard.XLFunctionsSunGard” and click “OK”. If it is not there, check what version of Office is running by looking on the Add/Remove Programs list from the Control Panel. Reinstall BizInsight selecting the correct version of Office.

For Excel 2007
open Excel and click on the Office button and then the Excel Options button.  Click on Add-ins in the left pane and under Active add-ins, check to see if you have both BizExcelerator add-ins listed.  You should see a COM add-in and an Excel add-in.  If the Excel add-in is missing, click on the Go button at the bottom of the screen next to the Manage add-ins drop down list.  Make sure Excel add-ins is the selected item in the Manage add-ins drop down list.  Check to see if there is BizExceleratorSunGard item listed and whether it is checked.  If it isn’t there, click on Automation and find the entry named “BizNetXLSungard.XLFunctionsSunGard” and add it.  Then make sure it is checked in the list.  Close out of Excel and go back in again and check to see if both Add-ins are listed now.
 
3. If you are using Excel 2007 or Excel 2010 and the file format is .xlsx, save the report as a .xlsb file or .xls.  Also remove the path from in front of the function that is evaluating to #NAME so that there is nothing between the "=" and the function name.  For example if the function looks like this:

='http://insightsungard/BizNetDocMgr/Excel BizExcelerator Documents/Sungard Monthly Balance Sheet.xls'!MTDENDBAL($B13,$C$4,$C$5,....)

Change the function to remove the path so that it looks like this:

=MTDENDBAL($B13,$C$4,$C$5,....)

4. Check to see if BizInsight was installed. Go to the Control Panel from the Start menu and select Add/Remove Programs. Look for BizExceleratorSungard. If it is not there, reinstall the program using the installation CD.

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