Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating links from one worksheet to another worksheet
I have multiple worksheets within a single workbook.
Multiple lines from all worksheets are linked to a single worksheet within the same workbook. (Kind of a table of contents.) I can not get the links to update when I change the original worksheet. It does not ask if I want to update when I open it neither does it do it automatically (I have tried both settings within "Options"). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating links from one worksheet to another worksheet
Hi Eileen,
The 'update links' feature only applies to links to external workbooks. For internal worksheet links, make sure calculation is set to 'automatic' (see Tools|Options|Calculation), otherwise press F9 to force a recalculation. One other thing that can interfere with this is having circular references - if you see something like 'Circular: A1' on the status bar, you've got such a problem and you'll need to fix it (or use iteration if the circular referencing is essential). Cheers "Eileen" wrote in message ... I have multiple worksheets within a single workbook. Multiple lines from all worksheets are linked to a single worksheet within the same workbook. (Kind of a table of contents.) I can not get the links to update when I change the original worksheet. It does not ask if I want to update when I open it neither does it do it automatically (I have tried both settings within "Options"). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with updating external links | Excel Discussion (Misc queries) | |||
Updating links | Excel Discussion (Misc queries) | |||
Updating links to closed workbooks | Excel Discussion (Misc queries) | |||
Delete ENTIRE row after updating info in worksheet. | Excel Worksheet Functions | |||
?? Links Not Updating ?? | Excel Discussion (Misc queries) |