Error Message Wkbk Open
 

I am trying find out why the following message is
displayed when the workbook is opened and the implications
of ignoring it. I'm using Excel 2002.

"Cannot find XLQUERY.XLS!Register.DClick, which has been
assigned to run each time [BVRFY2004.xls]Start is opened.
Continuing could cause errors. Cancel opening
[BVRFY2004.xls]Start?"

In the ThisWorkbook module, there are no procedures
assigned to the Workbook Open Event. There is a sheet
named Start in the wkb. There is a procedure that uses MS
Query to retrieve data from an external database and
display the data on a sheet (not the Start sheet).

Any help will be appreciated.

Tom

Error Message Wkbk Open
 

Tom

Go to the QueryTable properties (from the External Data toolbar). There is
a checkbox that says something like "Refresh this query when the workbook
opens" Try unchecking that if it's checked. That shouldn't necessarily
give you an error, but if the error goes away when you uncheck it, it may
help you narrow down the cause of the problem.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Tom Ulincy" wrote in message
...
I am trying find out why the following message is
displayed when the workbook is opened and the implications
of ignoring it. I'm using Excel 2002.

"Cannot find XLQUERY.XLS!Register.DClick, which has been
assigned to run each time [BVRFY2004.xls]Start is opened.
Continuing could cause errors. Cancel opening
[BVRFY2004.xls]Start?"

In the ThisWorkbook module, there are no procedures
assigned to the Workbook Open Event. There is a sheet
named Start in the wkb. There is a procedure that uses MS
Query to retrieve data from an external database and
display the data on a sheet (not the Start sheet).

Any help will be appreciated.

Tom