Linking to several other spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a master spread sheet which links to several other spread sheets.
When the other spread sheets are closed the links fails with a '#VALUE'
error. When it opens it asks if I want the links updated which I respond with
update. This only occurs with some cells. What do I need to change to get it
to update these values reliably.
 
First open any source workbooks, then open the workbook with the links. You
probably won't even be asked if you want to update the links.
 

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

Excel file linking 1
This workbook contains links to other data sources 1
Stop marco allert and update link allert when opening spreadsheet 1
Compare two spreadsheet 4
"Web" Command Bar always appears on start up 2
Linking Spread Sheets 1
Excel Function 1
Excel Disallow movement of embedded PDF 2

Back
Top