When you open that file, it should ask you if you want to update - choose "do
not update" otherwise you will have to open the other file too.

"ghynes" wrote:


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?


--
ghynes