Update links to closed spreadsheet

  • Thread starter Thread starter carlossaltz
  • Start date Start date
C

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
 
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
 
Am I supposed to include the source workbook reference within quotatio
marks or without the quotation marks
 
with quotes. make sure you have the full path in the first instance, an
make sure you have the .xls in the second instance
 
Back
Top