No, the formula requires the second file to be open.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ghynes" wrote in
message ...

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