Microsoft KB Archive/116176

= XL: Err Msg: File Error, Cannot Find XLODBC.DLL =

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
File Error

Cannot find XLODBC.DLL.

-or-

Attempt to register XLODBC.XLA failed.

-or-

Unable to copy add-in to library.

Macintosh
Attempt to register XLODBC code resource failed.



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\LIBRARY\MSQUERY, and click OK. Click NO when you receive the following message:

Copy XLODBC.XLA to Microsoft Excel Add-in Library?

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.

</li></ol>

Microsoft Excel for the Macintosh
To work around this problem in Microsoft Excel for the Macintosh, follow these steps: <ol> Delete the XLODBC.XLA file from the Microsoft Excel 5:Macro Library folder.</li> From the Tools menu, choose Add-ins.</li> 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.</li> Choose No when you receive the following message:

Copy XLODBC.XLA to Microsoft Excel Add-in Library?

You do not want to copy the file. The proper location of XLODBC.XLA (Microsoft Excel 5:Macro Library:MSQuery) will be retained.</li></ol>

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.