Import External Data
 

I've got a small query set-up in a spreadsheet using:

DataImport External DataImport Data...

When the workbook is opened a window appears titled "Query Refresh" and
asking if I'd like to either
-Enable automatic refresh, or
-Disable automatic refresh

Is it possible to get rid of this warning so that it just always
updates when the file is opened, I've played around with the properties
of the query but can't seem to suss it out

Any help greatly appreciated
J

Import External Data
 

http://support.microsoft.com/kb/248204


WhytheQ wrote:
I've got a small query set-up in a spreadsheet using:

DataImport External DataImport Data...

When the workbook is opened a window appears titled "Query Refresh" and
asking if I'd like to either
-Enable automatic refresh, or
-Disable automatic refresh

Is it possible to get rid of this warning so that it just always
updates when the file is opened, I've played around with the properties
of the query but can't seem to suss it out

Any help greatly appreciated
J