How can I add a row in a source worksheet while maintaining existing links to
secondary docs.

ie cells E56 - H 56 are linked to a cells in a different worksheet. I add a
new row of data & E56-H56 become new E57-H57. In the linked sheets the data
changes to the new E56-H56. I want it to continue to link to the data that
was in the original cells.

Direct links will update, as you've already discovered. So you'll have to use
INDIRECT references to keep that from happening.

=INDIRECT("Sheet2!E56")-INDIRECT("Sheet2!H56")

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"keith264" wrote:

How can I add a row in a source worksheet while maintaining existing links to
secondary docs.

ie cells E56 - H 56 are linked to a cells in a different worksheet. I add a
new row of data & E56-H56 become new E57-H57. In the linked sheets the data
changes to the new E56-H56. I want it to continue to link to the data that
was in the original cells.