Home |
Search |
Today's Posts |
#1
|
|||
|
|||
links to workbooks not adjusting for row deletions or additions
I have two workbooks that link togather. When adding rows to the referenced
workbook the linked cell in the second workbook does not adjust accordingly to follow the originally referenced cell. Example: A1 becomes A2 when I add a row, but the linked workbook still references A1. I need to have the second workbook reference the original cell no matter if I add or delete rows. Any help appreciatted. |
#2
|
|||
|
|||
Be sure to use the " $ " in your addressing code - as instead of A1
$A$1 "the1girlgearhead" wrote: I have two workbooks that link togather. When adding rows to the referenced workbook the linked cell in the second workbook does not adjust accordingly to follow the originally referenced cell. Example: A1 becomes A2 when I add a row, but the linked workbook still references A1. I need to have the second workbook reference the original cell no matter if I add or delete rows. Any help appreciatted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links between workbooks and emailing workbook | Excel Worksheet Functions | |||
How do I move workbooks w/o having to reset the links? | New Users to Excel | |||
Links between workbooks | Excel Discussion (Misc queries) | |||
Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) |