Links pull wrong line when rows are added

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Links error when insert line/row to source workbook 1
links not correct 2
Links do move when a row is added 1
Row #s Not Advancing When I Copy Formula 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Updating Formulas 2
Linking Workbooks 7
Linking problems in Excel 2007 2

Back
Top