Go to Edit | Links | click update values .....





On Apr 1, 8:42*pm, NPell wrote:
I have formulas that link to other workbooks, which works fine when
they are open.
But if they are closed it says #VALUE! ... as soon as i open the file
it updates.
Is there anyway i can get this to update without opening the file, to
prevent me having to open the files that they are referring to every
time??
Thanks if you can help.