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