software

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,
StefiIn 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 Studentquot;Stefiquot; wrote:

gt; Hi All,
gt;
gt; I'd like to make a link pointing to a source cell in another workbook
gt; containing a SUM function. My problem is that the reference of this source
gt; cell changes when new rows are inserted in the source sheet.
gt;
gt; How can this problem be resolved?
gt;
gt; Thanks,
gt; Stefi
gt;

Thanks Gary, fine!
Stefi?ary''s Student??ezt ?rta:

gt; In Sheet1 A1 enter:
gt;
gt; =Sheet2!A3
gt;
gt; This form will track inserted rows. So if two rows are inserted at the top
gt; of Sheet2,
gt; the formula will become =Sheet2!A5
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Stefiquot; wrote:
gt;
gt; gt; Hi All,
gt; gt;
gt; gt; I'd like to make a link pointing to a source cell in another workbook
gt; gt; containing a SUM function. My problem is that the reference of this source
gt; gt; cell changes when new rows are inserted in the source sheet.
gt; gt;
gt; gt; How can this problem be resolved?
gt; gt;
gt; gt; Thanks,
gt; gt; Stefi
gt; gt;