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
|