MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Possible to Auto Refresh Web Queries?


Posted by Paul on September 14, 2001 5:55 AM

Hi,

I have part of my spreadsheet linked to data on a website, and would like to know if there is any way to automatically refresh the data every few minutes, as it is awkard to refresh it manually. Any ideas?

Cheers

Paul


Posted by lenze on September 14, 2001 7:13 AM

Paul:
You can set how your query refreshes under Data>Get External Data>Data Range Properties. Look under refresh control.

Posted by Mark W. on September 14, 2001 7:29 AM

lenze, to the best of my knowledge the degree of
control that Paul is seeking is not available in
Excel 97. It is supported in Excel 2000. :

Posted by lenze on September 14, 2001 7:40 AM

Good Point. Mark