Links do move when a row is added

D

Dana

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.
 
M

macropod

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
 
Top