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
 
Top