formula recalculation in Excel 2003 - oddity?
 

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?

formula recalculation in Excel 2003 - oddity?
 

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

"Jarek Kujawa" wrote in message
...
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?

formula recalculation in Excel 2003 - oddity?
 

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

Regards,
Stefi


€žJarek Kujawa€� ezt Ã*rta:

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?

formula recalculation in Excel 2003 - oddity?
 

cells were formatted as General

thanks a lot Charles, that worked perfect

On 18 Cze, 11:13, "Charles Williams"
wrote:
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 Sitehttp://www.decisionmodels.com

"Jarek Kujawa" wrote in message

...



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?- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -