Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My rows are off by one row, ie. data on line 10 should line up wi. | New Users to Excel | |||
How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) | |||
line chart displays wrong values | Charts and Charting in Excel | |||
Using Links & inserting rows into Excel - help? | New Users to Excel | |||
how to format pull down rows | Excel Worksheet Functions |