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.

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.