"Cannot Access <FILENAME.XLA>" Opening Add-Ins Dialog Box

ID: Q126998

The information in this article applies to:

Microsoft Excel for Windows, version 5.0c
Microsoft Office for Windows, version 4.3c-CD

SYMPTOMS

In Microsoft Excel, when you choose Add-Ins from the Tools menu, you may receive the following error message

Cannot access '<FILENAME.XLA>'

where FILENAME.XLA is any of the following files:


   ATPVBAEN.XLA
   AUTOSAVE.XLA
   ADDINFNS.XLA
   ANALYSF.XLA
   ANALYSIS.XLA
   QE.XLA
   VIEWS.XLA
   XLSCAN.XLA

This error message appears two times for each of the files listed above that are selected in the Add-Ins dialog box. Additionally, when the Add-Ins dialog box appears, the add-in that corresponds to the file listed in the error message does not appear in the Add-Ins Available list.

CAUSE

This behavior occurs when you install Microsoft Excel using the Microsoft Office version 4.3c-CD Setup program. The behavior occurs when you load one of the add-ins listed above using the Add-Ins dialog box, close Microsoft Excel, and then start Microsoft Excel again. The error message does not occur until you choose Add-Ins from the Tools menu in the second session of Microsoft Excel.

Note that this behavior may also occur when you perform a network installation of Microsoft Excel, or if you are manually adding any of the add-ins listed above to the EXCEL5.INI file.

WORKAROUNDS

To work around this problem, do the following:

Note that the following steps assume that you have received the error message described above. If you receive the error message above, the information necessary for loading the add-in is removed from the EXCEL5.INI file when you close Microsoft Excel. Steps 1-4 below are necessary in order for the add-in file to be referenced in the EXCEL5.INI file again.

Close Microsoft Excel, and then start Microsoft Excel again.

From the Tools menu, choose Add-Ins.

In the list of Add-ins Available, select the check box next to any add-ins that you want to load, and choose OK.

Close Microsoft Excel.

In Notepad, or in another text editor, open the EXCEL5.INI file (located in your Microsoft Windows directory) and add the /F or /R switch to the appropriate add-in lines in the [Microsoft Excel] section as in the following example


      OPEN=/F C:\MSOFFICE\EXCEL\LIBRARY\ANALYSIS\ATPVBAEN.XLA
      OPEN1=/F /R C:\MSOFFICE\EXCEL\LIBRARY\AUTOSAVE.XLA
      OPEN2=/F C:\MSOFFICE\EXCEL\LIBRARY\ADDINFNS.XLA
      OPEN3=/F C:\MSOFFICE\EXCEL\LIBRARY\ANALYSIS\ANALYSF.XLA
      OPEN4=/F C:\MSOFFICE\EXCEL\LIBRARY\ANALYSIS\ANALYSIS.XLA
      OPEN5=/F /R C:\MSOFFICE\EXCEL\LIBRARY\MSQUERY\QE.XLA
      OPEN5=/F /R C:\MSOFFICE\EXCEL\LIBRARY\VIEWS.XLA
      OPEN6=/F /R C:\MSOFFICE\EXCEL\LIBRARY\XLSCAN.XLA

where C:\MSOFFICE\EXCEL is the directory to which you installed Microsoft Excel. Note that the number following the OPEN command may be different in your EXCEL5.INI file.

MORE INFORMATION

When the above error occurs, if you attempt to add the add-in file (listed in the error message) during the same Microsoft Excel session, you receive the following error message:

Cannot access '<FILENAME.XLA>'

If you choose Cancel, you receive the following error message:

'<FILENAME.XLA>' is not a valid add-in

The following table lists the add-in files that cause this problem and their corresponding add-in name listed in the Add-Ins dialog box.


   Filename                            Add-In
   --------------------------------------------------------

   ATPVBAEN.XLA                 Analysis ToolPak - VBA
   AUTOSAVE.XLA                       AutoSave
   ADDINFNS.XLA             MS Excel 4.0 Add-in Functions
   ANALYSF.XLA              MS Excel 4.0 Analysis Functions
   ANALYSIS.XLA             MS Excel 4.0 Analysis Tools
   QE.XLA                            Q+E Add-In
   VIEWS.XLA                        View Manager
   XLSCAN.XLA                Microsoft Excel Virus Search

For more information about using switches in the Microsoft Excel .INI file, please see the following article(s) in the Microsoft Knowledge Base:

Q100615 : Excel: Using the /F Switch to Load Add-in Macros

Additional query words: 4.30c-CD 5.00c

Keywords : xlwin
Version : 5.00c
Platform : WINDOWS
Issue type :