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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Spreadsheets keep moving 0
linking spreadsheets to word 7
Lookups - how to obtain data from a master spreadsheet into another 5
trying to create a link to a link in Excel (2007) 3
INVISIBLE SPREADSHEET with Excel 2007 8
Accessing Data in an Open Excel Spreadsheet 2

Back
Top