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