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.