I don't understand your problem.

If you create a link where Sheet1, cell D10 is linked to (and displays) the
value in Sheet2, cell E5, and you insert a row in Sheet2, *above* E5, making
that now E6, that value in the new E6 will *still* display on Sheet1, D10.

You should notice that the 'link' formula changes to compensate for the
insertion.

Doesn't this happen for you?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"MikeDH" wrote in message
...
Just a general question:
Is there any way to either:

1) Paste-special - Paste Link so the cells are then filled with absolute
references ($x$#) instead of standard reference format (x#)
or
2) Apply absolute reference format to all cell-references in a selected
array?

Essentially, I need to be able to paste-link in a way that the information
referenced is the same even if something should be inserted above it in
the
referenced sheet. Any ideas or solutions would be greatly appreciated.
-MikeDH