Assume I have a column of numbers, in a file named Source. (range is B2:B10).
These cells are linked to a column in a file named Destination(range is
E2:E10).
If I add a new row 5 to the source, is there a way I can get the previously
linked cells in Destination to continue to display the correct values.
After adding the new row 5 in source, rows in Destination below row 5
display values from rows below (in the Source file).
I hope this is not too confusing a question (I am confused).
If it of importance, the linking was done using Paste Link in the Paste
Special dialog.
Thanks.

Hi PA

You can try to use Row() in your formula

=INDIRECT("Sheet2!A"&ROW())

It always point to the same row then


--
Regards Ron de Bruin
http://www.rondebruin.nl



"PA" <(E-Mail Removed)> wrote in message news:7D6A413A-F616-42AB-BE90-(E-Mail Removed)...
> Assume I have a column of numbers, in a file named Source. (range is B2:B10).
> These cells are linked to a column in a file named Destination(range is
> E2:E10).
> If I add a new row 5 to the source, is there a way I can get the previously
> linked cells in Destination to continue to display the correct values.
> After adding the new row 5 in source, rows in Destination below row 5
> display values from rows below (in the Source file).
> I hope this is not too confusing a question (I am confused).
> If it of importance, the linking was done using Paste Link in the Paste
> Special dialog.
> Thanks.