Update links to closed spreadsheet

[carlossaltz]

I have an excel spreadsheet with formulas linked to data in anothe
spreadsheet. The spreadsheet with the source data is not opened. Whe
I press the Update Link button, the cells with the formulas linked t
the closed spreadsheet returns a #VALUE# indicator. I have to open th
source spreadsheet so that the Update Link will return the correct data
Why doesn't Excel extract the data from the source spreadsheet when i
is closed

 

[MDubbelboer]

too many links could exist


write a macro to open the related spreadsheet when the firs
spreadsheet is opened. once the links have been updated it can clos
the related spreadshee

 

[carlossaltz]

Am I supposed to include the source workbook reference within quotatio
marks or without the quotation marks

 

[MDubbelboer]

with quotes. make sure you have the full path in the first instance, an
make sure you have the .xls in the second instance