Query Refresh

  • Thread starter Thread starter sbextra2
  • Start date Start date
S

sbextra2

Have a workbook that refreshes data on open. I've just
loaded Excel 2003 and each time I open the file it gives
me the Query Refresh warning about importing external
data into excel. It gives me the two buttons for "Enable
Automatic Refresh" and "Disable Automatic Refresh" but it
doesn't give me the checkbox to "Enable automatic query
refresh for all workbooks and don not show this warning
again."

Am I missing something? How do I stop this thing from
warning me every time I open the file?

Thanks.
 
I have unloaded Excel 2003 now, but try looking in the security settings.
It sounds like one of those things that is attributable to that, to stop
malicious attack.

May be wide of the mark, but give it a try. Normally however, these
settings are global and you may not want the trade-off of lowering security.

--
HTH
Nick Hodge
Southampton, England

(e-mail address removed)
 
Back
Top