What is "Enable Background Refresh" in Excel 2003 ?

P

Patrick

We have created an Excel Spreadsheet by using MS Query to access a SQL
Server database.

End user doesn't like to get the pop up "Enable AutoRefresh" everytime when
he opens the Excel spreadsheet & he doesn't want to use Tools --> Run Query.
Most likely, he feels unfortunable to encounter a pop up message or does an
extra step to refresh data.

We would like to know by turning on "Enable Background Refresh" checkbox,
does the data will be refreshed automatically ? If not, what is the purpose
for this checkbox ?

Is there any suggestion in our case ?

Thanks
 

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

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
enable automatic refresh 0
Refresh Bloomberg data in an excel file from a script 4
Enable Automatic Refresh 3
Excel 2003, query doesn't refresh sometimes 0

Top