when adding row in linked workbooks, data in receiver loses a row
 

I have two workbooks linked, and if I add a row to the data source, the cell
that the receiving worksheet holds, looses that new row and everything
shifts. I want the receiving worksheet to stay the same when I add a row to
the data source. I tried using the $ but it did not work.

when adding row in linked workbooks, data in receiver loses a row
 

hi, Janice !

I have two workbooks linked, and if I add a row to the data source
the cell that the receiving worksheet holds, looses that new row and everything shifts.
I want the receiving worksheet to stay the same when I add a row to the data source.
I tried using the $ but it did not work.

instead of using a "direct" reference to "the cell", use index(<column,<row_number)
of some form with indirect(... assuming the two workbooks will be open -?-

hth,
hector.