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