Cell displays wrong total after copying formula

[Guest]

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.)

 

[JE McGimpsey]

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

 

[Bernard Liengme]

Can't say I have ever seen this. What XL version?
best wishes

 

[Guest]

Yes, Automatic Calculation is/was enabled.

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

 

[Guest]

XL version is 2003 (11.8120.8122) SP2

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

 

[Guest]

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.