Query/Automatic Refresh

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.
 
J

J.H.A. van de Weijer

Hi,

I had the same problem and found a solution. Apply the attached reg file to
your registry and your problems are over.

Regards,
Jan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
How can I 'Enable Automatic Refresh' for Query Refresh by default 0
Enable automatic refresh 0
query to external data 3
How to Diable automatic query refresh? 0
2003 Automatic Query Refresh 0

Top