Error msg

[Mervyn Thomas]

When I open a particular workbook, I get an Excel error message " cannot
find C:\.......MSQuery......Dclick Cancel Opening?"
Dclick was a macro I wrote years ago and is now out of use and who knows
where. How can I find the reference to this maco and/or disable the
error message?

 

[Mervyn Thomas]

Joel - thanks for your reply which helps but has not soved the problem.
In Excel 2007 I found the "name manager" under <Formulae> and although there
was much junk which I deleted there were no query references at all.
I then went to the <Data, Connections> tab and deleted all but the single
query in the workbook.
In the VB editor there are no apparent macros either in the workbook or
Personal.xlsb
In Excel 2007 I cannot find file - Properties - Custom as you suggested.
The exact error message implies that there is a macro asigned to run when
XLQUERY.XLA runs . I will go hunting for this query which must be somewhere!
Mervyn

 

[Mervyn Thomas]

I found the Query in the Microsof Office folders and it was in fact a
shortcut to some unknown previously existing drive. I renamed the file
XLQueryOLD.XLA but the error message on opening my worksheet still refers to
XLQuery.XLA. I cannot find this file anywhere so I am assuming it is still
a reference in my worksheet which I canot find! Help!