Can you help me out with this? if works fine if the external source is
open but returns a #value if its closed. is there anyway of correcting
this so that it will pull from the external when it is closed?


--
ghynes
------------------------------------------------------------------------
ghynes's Profile: http://www.excelforum.com/member.php...o&userid=26587
View this thread: http://www.excelforum.com/showthread...hreadid=398561