Hello again,

I've checked the references and the reference set is the same when
connected to the network and when running from the laptop.

I have also found that if I complete an operation within the workbook
while connected and then disconnect from the network, the workbook
doesn't fall over if an operation is carried out while disconnected
from the network. I'm assuming that this is because all the necessary
modules have been properly loaded into memory? However, i find that
when I try and close the workbook after reconnecting to the network it
just hangs and has to be stopped with task manager to get Excel working
again.

I've now tried reorganising and further optimising the code but this
seems to just shift the problem to another part of the workbook. On
occasional attempts where it has worked, the problem gets passed to
other network based excel files that are open and they start throwing
the errors.

I'm getting to think it may be more a server/network problem, but how
do I go about proving this or solving the problem.

Cheers
Christian


--
ging18
------------------------------------------------------------------------
ging18's Profile: http://www.excelforum.com/member.php...o&userid=36990
View this thread: http://www.excelforum.com/showthread...hreadid=567145