In Sheet1 A1 enter:

=Sheet2!A3

This form will track inserted rows. So if two rows are inserted at the top
of Sheet2,
the formula will become =Sheet2!A5
--
Gary's Student


"Stefi" wrote:

Hi All,

I'd like to make a link pointing to a source cell in another workbook
containing a SUM function. My problem is that the reference of this source
cell changes when new rows are inserted in the source sheet.

How can this problem be resolved?

Thanks,
Stefi