5 pts.
 Error message on startup of Excel 2003 workbook
Could anyone tell me what the following error message means and how i could fix it?

Cannot find XLQUERY.XLA!Register.DClick, which has been assigned to run each time [file name]key is opened. Continuing could cause errors. Cancel opening [file name]key?



Software/Hardware used:
ASKED: November 10, 2010  11:51 AM
UPDATED: May 18, 2011  9:54 PM

Answer Wiki:
Here is the Microsoft Support Page that relates to your error use this and see if it helps. http://support.microsoft.com/kb/277620 It sounds like missing or corrupt Add-Ins. This behavior may occur when either of the following conditions is happend: a) U may try to save a workbook that contains a query to external data in the Microsoft Excel 5.0/95 format or in the Microsoft Excel dual format. Try the following .... Copy the XLQuery.xla file from one of the old computers to the new computers that has Microsoft Office XP installed. The spreadsheets that u created by using the add-in, must access the code that is in the XLQuery add-in. OR U may first uninstall the application i.e. excel 2003 and then reinstall the same ! OR Also u may try to save the file in the current version format only, and then use Microsoft Visual Basic for Applications code to delete the hidden defined names (VBA / VBScript). The defined names retain the information so that even if u save the file in the current version format only.
Last Wiki Answer Submitted:  November 10, 2010  5:44 pm  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _