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?