Hi,
I have a workbook with around 350 sheets each with a web query in. If I
try to update all, about a half of the sheets will successfully update
before the message 'www..... The access to this internet site has
exceeded the allotted time'.
Can anyone suggest a workaround? For example would it be possible to
update the web queries in batches of 100?
Thanks,
Bertie
--
claytorm
------------------------------------------------------------------------
claytorm's Profile:
http://www.excelforum.com/member.php...o&userid=11610
View this thread:
http://www.excelforum.com/showthread...hreadid=484293