Data Query
 

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.

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


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=377620