Web Query Refresh problem
 

Hi

I've set up a workbook that contains about 75 sheets. Each sheet contains a
web query. I then have a summary sheet which summarises the actual part of
information that I want from each web page.

Everything works fine, most of the time. I've set up a little button to
'refresh all data'. However, sometimes the refresh doesnt seem to work on
some of the sheets. It actually pulls data from a website which I've set up
on a different sheet. If, however, you go to that individual sheet, and
manually refresh that sheet, it pulls through the correct data from the web.
Sometimes it works ok, and other times it doesnt.

I'm really stumpped on this! Help would be appreciated!
Thanks
Tone