excell
 

but watch out
if the linked cell is included within an array formula. The cut and paste of
this linked /individual cell cannot be done alone without the whole array..
if there are formula with volatile function which is referred on this linked
cell....you may possibly loose the linking advantage.

"driller" wrote:

1.open all workbooks that are cross-linked with that cell.
2. if this cell is not referred by other workbooks,
right-click mousetcutpaste : to any convenient location you desired,
within the same sheet, if possible.

happy holidays...hohoho
"idoright69" wrote:

how do i keep a linked cell location the same when adding new row...