Link to external s/sheet changes to #Value!
 

hi dave f..
i do not use vlookup, yet i believe the other generic "lookup()" function
can do the job for such, without #value! error even when the sorce book is
closed...editlinksupdate is possile and integral...
thanks for the info...

"Dave F" wrote:

VLOOKUP does not work when it references data in a closed workbook.

Dave
--
Brevity is the soul of wit.


"will" wrote:

Hi,

I have a vlookup link to an external spreadsheet. This works fine whilst the
external spreadsheet is open, but if it is closed and I update links in the
original spreadsheet, the formula result changes to #value! Why is this and
can I stop it?

Thanks,

Will