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").

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").