Links pull wrong line when rows are added
 

I have several large spreadsheets that have some linked formulas between
them. Sometimes, if a row gets added on one spreadsheet, the other
spreadsheet with a linking formula now pulls from one line above where it
should (it's not recognizing that a row was added). Do I ALWAYS need to open
all the linked files when working with them? I click to update when I open
the file. I'm working in Excel 2002. Please help! - I'm sick of re-doing my
linked formulas. Thanks.

You can use INDIRECT in a formula linking to another cell

=INDIRECT("A1")

will always link to A1 regardless of how many rows you add

From a layout point of view and IMHO one should avoid a design where one
adds rows at the top making cell references change.


Regards,

Peo Sjoblom

"nifferearly" wrote:

I have several large spreadsheets that have some linked formulas between
them. Sometimes, if a row gets added on one spreadsheet, the other
spreadsheet with a linking formula now pulls from one line above where it
should (it's not recognizing that a row was added). Do I ALWAYS need to open
all the linked files when working with them? I click to update when I open
the file. I'm working in Excel 2002. Please help! - I'm sick of re-doing my
linked formulas. Thanks.