Error msg when opening Excel (but works anyway)
 

I have macros in my file. When I open it I get a msg:
Cannot find 'C:\Program files\Microsoft Office\Office
11\Library\Msquery\Xlquery.xla'!Register.DClick, which has been assigned to
run each time .....file is open

My file works anyway. I have a refresh to ACCESS (query).

This is annoying....how can I get rid of the msg. thx

Hi Greg, did you resolve your DClick problem at all? I ask because I am
getting the same error when I publish a document to Sharepoint Team Services
- doesn't happen under any other circumstances: different user access right
levels, running local, running over Citrix, etc.

"Greg" wrote:

I have macros in my file. When I open it I get a msg:
Cannot find 'C:\Program files\Microsoft Office\Office
11\Library\Msquery\Xlquery.xla'!Register.DClick, ...

Greg, have you saved your Excel workbook to a different versions at all? If
so, that may be your answer. I had my issue posted in the Sharepoint
TS.Admin thread and Roger replied with this post:
"Xlquery.xla was used in earlier versions of Excel for executing queries.
Office XP doesn't have or use xlquery.xla, but if the spreadsheet is saved
in Excel 5.0/95 format, the error may come up when opening it. Microsoft has
a workaround in KB277620 (link below). Basically, make sure you are saving
it in the latest format.

http://support.microsoft.com/default...b;en-us;277620

Roger"

I found that although I was using Excel 2000 to create the query, Excel had
been globally set to save down to Excel 95... once I fixed that and recreated
my Excel file the problem went away. Good luck.

Rgds
Sara