Hi,

i have not tested but
how about updating the links by using 'UpdateLink' method at proper time
in the loop?

UpdateLink
http://msdn.microsoft.com/library/en...HV05205722.asp

--
HTH
okaizawa

wrote:
Hi again, unfortunately DoEvents and Calculate do not solve the
problem, the external links still stay frozen while the macro is
running.

Any other ideas?
Thanks
Kai