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.