Link to external s/sheet changes to #Value!
 

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