| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking to several other spreadsheets
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Linking to several other spreadsheets
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. -- Gary''s Student - gsnu200744 "MarkS" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need lot of help with linking spreadsheets | Links and Linking in Excel | |||
| Linking Spreadsheets | Excel Worksheet Functions | |||
| Linking spreadsheets | Excel Discussion (Misc queries) | |||
| Linking two spreadsheets | New Users to Excel | |||
| Linking Spreadsheets | Excel Worksheet Functions | |||
Linear Mode
