Disable Query Refresh warning dialog box in Excel 2003

J

Jeff Koons

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

Peo Sjoblom

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

Enable automatic refresh 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Macro Code for bringing up Save As dialog box and changing file Type 0
enable automatic refresh 0
Include Field Names - check box not available in Excel 2007 0
excel external data range "failed to refresh" 0
Excel Macro Warning problems 0
Open Excel 2002 Attachment from Outlook 2002 0

Top