Links do move when a row is added
 

I have a spreadsheet where multiple rows may be added during the month, but
the linked spreasheet does not recognize this change.
I was wondering if there is a way to either:
1. have the links update automatically
2 or have the linked spreadsheet open automatically when the first
spreadsheet is opened.

Links do move when a row is added
 

Hi Dana,

If your links are to cells that have new data added ahead of them (eg a
'Totals' row), then naming those cells and linking to the named ranges will
resolve the issue.

Cheers

--
macropod
[MVP - Microsoft Word]


"Dana" wrote in message
...
I have a spreadsheet where multiple rows may be added during the month,
but
the linked spreasheet does not recognize this change.
I was wondering if there is a way to either:
1. have the links update automatically
2 or have the linked spreadsheet open automatically when the first
spreadsheet is opened.