Hello there,
I have the following question:
I have a spreadsheet where I query an external web page for data (say 15
different queries).
I set to refresh/re-query the data every 10 minutes (or similar). The
problem is that when the refresh time comes
it takes some time and whole spreadsheet is out of action. User can not do
anything but wait.
I would expect that getting external data should run as a background
activity allowing the user to scroll,
modify ect. the spreadsheet..
Is there any way around?
I did not use a code to query the webpage just the option in the menu.

Thank you

Hi,

Right click on the cell where you had created your web query. Then click on
Data Range Properties. Make sure the checkbox for "Enable Background
refresh" is checked.


--
Hope that helps.

Vergel Adriano


"R&D" wrote:

Hello there,
I have the following question:
I have a spreadsheet where I query an external web page for data (say 15
different queries).
I set to refresh/re-query the data every 10 minutes (or similar). The
problem is that when the refresh time comes
it takes some time and whole spreadsheet is out of action. User can not do
anything but wait.
I would expect that getting external data should run as a background
activity allowing the user to scroll,
modify ect. the spreadsheet..
Is there any way around?
I did not use a code to query the webpage just the option in the menu.

Thank you