| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cells linked to another workbook with a formula.
I have a workbook that is linked to another workbook, but I have included a
formula at the beginning to ensure that no errors are returned (If(iserror(linked workbook A1 + Linked workbook B1),"",linked workbook A1 + Linked workbook B1))). This works fine when both workbooks are open, but when I attempt to open the linked file on its own it doesn't appear to update the information. When I check the link status, it shows that it is ok. Any help would be appreciated. Thanks, -- Drew |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cells linked to another workbook with a formula.
From the top menu (assuming Excel 2003 or lower), select...
Edit Links Update Values -- Hope this helps. Thanks in advance for your feedback. Gary Brown "Drew" wrote: I have a workbook that is linked to another workbook, but I have included a formula at the beginning to ensure that no errors are returned (If(iserror(linked workbook A1 + Linked workbook B1),"",linked workbook A1 + Linked workbook B1))). This works fine when both workbooks are open, but when I attempt to open the linked file on its own it doesn't appear to update the information. When I check the link status, it shows that it is ok. Any help would be appreciated. Thanks, -- Drew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Cells in a Workbook Linked to Other Workbooks | Excel Discussion (Misc queries) | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| cells linked to others in same workbook not updating | Excel Discussion (Misc queries) | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Sorting mixed up linked cells in a workbook? | Excel Worksheet Functions | |||
Linear Mode
