Error Message after MS-Query in Excel

[JustATheory]

Greetings,

I run a series of MS-Query queries in Excel VBA, using various tabs for the tables. Once I have the finished product, I have those tabs deleted and have the data in the final tab. I send this report to users but am receiving this error message:

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

What is the macro command that I can use so that it no longer displays this message.

Thanks,
Andy

 

[SkipVought]

Hi,

You have a QueryTable that has a Data Range Properties property assigned to Refresh data on file open. UNCHECK that box.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}