Disable Query Refresh warning dialog box in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Office 2003. I have an Excel file that pulls data from a Microsoft
Query. Every time I open the Excel file, a 'Query Refresh' dialog box appears
allowing me to choose between 'Enable automatic refresh' or 'Disable
automatic refresh'. I want to be able to permanently disable this box from
appearing every time I open the file. I was told that this dialog box in
Office XP would allow you to select to not see it again, but this option is
not available in Office 2003. I have tried every setting I can think of, but
nothing seems to work. Also, there seem to be questions from other users
about this, but it seems that no one has any answers.
 
What happens if yopu right click inside the query table/results in Excel and
select
Data Range Properties, there I have an option to check/uncheck
Refresh data on file open, uncheck that

Regards,

Peo Sjoblom
 

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

Automatic Query Refresh 4
Refreshing a query 1
Database Query Missing 4
Stopping "Query Refresh" messages 2
File Download - Security Warning 5
Removing some alert messages 2
External Data Refresh Issues 0
Excell 2021 0

Back
Top