formula recalculation in Excel 2003 - oddity?

[Jarek Kujawa]

have 2 worksheets in a workbook with SUM functions summing up several
cells/rows above them
in worksheet 1 SOME of those SUM functions recalculate ONLY when
they're edited and entered again
OTHERS in the same worksheet, same row, DO recalculate
ALL data are numbers

I seem to have tried everything (that I know of):
1. change calculation from Manual to Automatic in Tools->Options
2. F9 and SHIFT+F9
3. Calculate method with BeforePrint event (they only recalculated
when I used cell.Formula = cell.Formula method)

but to no avail
(did not tick save and re-open options in Tools->Options deliberately)

another worksheet (worksheet 2) in same workbook looks like a mirror
copy of the a/m
same formulae DO recalculate with no problem

has anyone had such a problem?

 

[Charles Williams]

Make sure the cells are not formatted as text

Then try Ctr-Alt-Shift-F9 to rebuild the dependency trees and do a full
calculate

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Stefi]

My tip is that some referred cell's format are different from others behaving
normally. Check it!

Regards,
Stefi


„Jarek Kujawa†ezt írta:

 

[Jarek Kujawa]

cells were formatted as General

thanks a lot Charles, that worked perfect