Linking to several other spreadsheets

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.
 
G

Guest

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
Stop marco allert and update link allert when opening spreadsheet 1
"Web" Command Bar always appears on start up 2
Linking Spread Sheets 1
Command Button & Macro 2
Excel 2007 Crashes in Vista 5
Link spreadsheets by clicking on a field 1
Importing / Linking Dynamic Data or ASP Tables into Excel ? 1

Top