I currently have several (30) links of Imported data (web data) in a
spreadsheet. When I open the spreadsheet the links update immediately.
After this in order for me to refresh this data I have to click on a cell
where the data comes in and then go Data - Refresh Data. I have to do this
to each web page I have linked. Can someone please provide a simple macro
that will update all the web pages that I have linked in my spreadsheet at
the same time. That, is when I run this macro all the data links will
update.

Also, I have noticed that if you right click on a link in a spreadsheet and
go Data Range Properties that you can Refresh every X minutes - the problem
is that I would like to refresh this much more frequently but I can't change
this to less than one minute. Is it possible to auto refresh every X
seconds? (< 1 minute)


thanks for your help.

mike