formula recalculation in Excel 2003 - oddity?


J

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?
 
Ad

Advertisements

C

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
 
S

Stefi

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

Regards,
Stefi


„Jarek Kujawa†ezt írta:
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top