Article ID: 116176
Article Last Modified on 8/16/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 for Macintosh
- Microsoft Excel 5.0a for Macintosh
- Microsoft Query 2000
This article was previously published under Q116176
SYMPTOMS
If you are using a workstation installation of Microsoft Excel, and you choose the Add-ins command to add the ODBC add-in, you may receive any of the following error messages.
Windows 3.x or Windows 95
-or-
-or-
Macintosh
CAUSE
This problem occurs because the add-in manager places the XLODBC.XLA file in a folder (directory) that is different from the folder where the XLODBC.DLL is located. XLODBC.XLA is located in two places on your hard disk, and the add-in manager is attempting to access the file from the wrong location.
The XLODBC.XLA must be located in the same folder as the XLODBC.DLL file for the add-in to work with ODBC functionality. The Add-in Manager is using the copied XLODBC.XLA file located in the EXCEL\LIBRARY folder (the Macro Library:MS Query folder on the Macintosh) and cannot find XLODBC.DLL (which is located in the MSQUERY folder).
The Add-in Manager in Microsoft Excel does not recognize the MSQUERY folder as an add-in folder. Therefore, when you select the ODBC Add-in, the Microsoft Excel Add-in Manager attempts to copy the XLODBC.XLA file to the wrong folder.
NOTE: The file XLODBC.DLL is replaced with the file XLODBC32.DLL in Microsoft Excel 97.
WORKAROUND
To work around this problem, use the following appropriate procedure.
NOTE: Once you complete the appropriate workaround, you may want to change the rights for the server that the workstation is accessing such that the server is read-only. If the server is made read-only, the Add-in manager will be unable to copy the XLODBC.XLA file to the incorrect location.
Microsoft Excel for Windows
To work around this problem in Microsoft Excel for Windows, follow these steps:
- Delete the XLODBC.XLA file from the EXCEL\LIBRARY folder.
NOTE: It is not necessary to delete any files in Microsoft Excel 97.
- Click Add-ins from the Tools menu.
- Click Browse, in the Add-ins dialog box, click the XLODBC.XLA file from EXCEL\LIBRARY\MSQUERY, and click OK.
-or-
In Microsoft Excel 97, click Browse and click XLODBC.XLA from <Office folder>\OFFICE\LIBRARY\MSQUERY, and click OK. - Click NO when you receive the following message: You do not want to copy the file. The proper location of XLODBC.XLA and XLODBC.DLL on the shared network location will be retained.
- Confirm the proper reference of the XLODBC.XLA Add-in in your EXCEL5.INI for Microsoft Excel 5.0, located in the Windows folder on your local workstation. If the Add-in reference still points to EXCEL\LIBRARY, change this line to EXCEL\LIBRARY\MSQUERY, and save the EXCEL5.INI file.
NOTE: Make this change after you quit Microsoft Excel.
Microsoft Excel for the Macintosh
To work around this problem in Microsoft Excel for the Macintosh, follow these steps:
- Delete the XLODBC.XLA file from the Microsoft Excel 5:Macro Library folder.
- From the Tools menu, choose Add-ins.
- In the Add-ins dialog box, choose Browse, select the XLODBC.XLA file from the Microsoft Excel 5:Macro Library:MS Query folder, and choose OK.
- Choose No when you receive the following message: You do not want to copy the file. The proper location of XLODBC.XLA (Microsoft Excel 5:Macro Library:MSQuery) will be retained.
If you continue to have trouble using the ODBC add-in commands, quit Microsoft Excel and drag the Excel Settings (5) file from the Preferences folder to the Trash. Restart Microsoft Excel, and then repeat steps 1-4. Note that if you do this, all your custom settings will be reset to the default settings.
Additional query words: 5.00a 5.00c addin connection path not found
Keywords: kberrmsg kbbug kbpending KB116176