Adding a row in a linked worksheet

  • Thread starter Thread starter keith264
  • Start date Start date
K

keith264

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")
 
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")
 
Back
Top