Data Query

[Guest]

Hi there,

I have an excel file with multiple sheets. When I open the file, a prompt
is displayed asking whether to enable or disable refresh of query. As there
should be no queries in this workbook, I would like to locate the query, and
delete it. Any ideas ?

I know I could simply re-create the workbook, but i dont want to do this.

 

[Gary Brown]

Look for a named range in each of the spreadsheet pages which begins
Query....

If you delete this named range, this should disable the refresh data
message