Sometimes, when I copy a formula (usually the sum of a range) to another
cell, instead of getting the sum of the new cells, I get the sum of the old
cells. The formula is not set to absolute. For example, I copied the forumula
=SUM(D69) from cell D11 to cell C11. The formula in C11 is now =SUM(C6:C9).
But, instead of calculating C:6:C9, the cell is displays the total from the D
column.

Has anyone else encountered this problem? Does anyone know if this is an
issue with Excel? (This issue is difficult to search for.)

Make sure Calculation is set to Automatic (Tools/Options/Calculation...)

In article <AD1A039E-BF92-493E-A5F2-(E-Mail Removed)>,
Billbo <(E-Mail Removed)> wrote:

> Sometimes, when I copy a formula (usually the sum of a range) to another
> cell, instead of getting the sum of the new cells, I get the sum of the old
> cells. The formula is not set to absolute. For example, I copied the forumula
> =SUM(D69) from cell D11 to cell C11. The formula in C11 is now =SUM(C6:C9).
> But, instead of calculating C:6:C9, the cell is displays the total from the D
> column.
>
> Has anyone else encountered this problem? Does anyone know if this is an
> issue with Excel? (This issue is difficult to search for.)

Can't say I have ever seen this. What XL version?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Billbo" <(E-Mail Removed)> wrote in message
news:AD1A039E-BF92-493E-A5F2-(E-Mail Removed)...
> Sometimes, when I copy a formula (usually the sum of a range) to another
> cell, instead of getting the sum of the new cells, I get the sum of the
> old
> cells. The formula is not set to absolute. For example, I copied the
> forumula
> =SUM(D69) from cell D11 to cell C11. The formula in C11 is now
> =SUM(C6:C9).
> But, instead of calculating C:6:C9, the cell is displays the total from
> the D
> column.
>
> Has anyone else encountered this problem? Does anyone know if this is an
> issue with Excel? (This issue is difficult to search for.)

Yes, Automatic Calculation is/was enabled.

"JE McGimpsey" wrote:

> Make sure Calculation is set to Automatic (Tools/Options/Calculation...)
>
> In article <AD1A039E-BF92-493E-A5F2-(E-Mail Removed)>,
> Billbo <(E-Mail Removed)> wrote:
>
> > Sometimes, when I copy a formula (usually the sum of a range) to another
> > cell, instead of getting the sum of the new cells, I get the sum of the old
> > cells. The formula is not set to absolute. For example, I copied the forumula
> > =SUM(D69) from cell D11 to cell C11. The formula in C11 is now =SUM(C6:C9).
> > But, instead of calculating C:6:C9, the cell is displays the total from the D
> > column.
> >
> > Has anyone else encountered this problem? Does anyone know if this is an
> > issue with Excel? (This issue is difficult to search for.)
>

XL version is 2003 (11.8120.8122) SP2

"Bernard Liengme" wrote:

> Can't say I have ever seen this. What XL version?
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Billbo" <(E-Mail Removed)> wrote in message
> news:AD1A039E-BF92-493E-A5F2-(E-Mail Removed)...
> > Sometimes, when I copy a formula (usually the sum of a range) to another
> > cell, instead of getting the sum of the new cells, I get the sum of the
> > old
> > cells. The formula is not set to absolute. For example, I copied the
> > forumula
> > =SUM(D69) from cell D11 to cell C11. The formula in C11 is now
> > =SUM(C6:C9).
> > But, instead of calculating C:6:C9, the cell is displays the total from
> > the D
> > column.
> >
> > Has anyone else encountered this problem? Does anyone know if this is an
> > issue with Excel? (This issue is difficult to search for.)
>
>
>

Okay, now I see an error I made. I have the cell that contains the formula
referenced in the formula. Why it Excel did not complain and why the forumla
would copy in that fashion, I don't know. Anywhere in the spreadsheet I
copied the formula...the idential number displayed. Now that I corrected the
formula, the problem is gone. As with many computer issues, it is easier to
fix the problem than explain why it acted that way in the first place.

"Billbo" wrote:

> Sometimes, when I copy a formula (usually the sum of a range) to another
> cell, instead of getting the sum of the new cells, I get the sum of the old
> cells. The formula is not set to absolute. For example, I copied the forumula
> =SUM(D69) from cell D11 to cell C11. The formula in C11 is now =SUM(C6:C9).
> But, instead of calculating C:6:C9, the cell is displays the total from the D
> column.
>
> Has anyone else encountered this problem? Does anyone know if this is an
> issue with Excel? (This issue is difficult to search for.)