Cells will not always recaculate with Auto Calculation turned on.

[Doug Pribyl]

I have a customer who is having constant problems getting a
simple sumation formula automatically recalcualated. They
have several colums of numbers that are just added up.
When they change one of the numbers in one of the columns,
most of the time the cell with the sum formula stays the
same. If you force it with F9, it will then update most of
the time, but even then sometimes it will stay the same.
This is not happening on all spreadsheets, but
unfortunately it is happening on very important ones for
doing estimates. They are using Excel 2002 SP2 which we
updated to SP2 because of these problems. These
spreadheets were however created in an older version of
Excel - either 2000 or 97. They did work just fine on this
old computer. They are stored on a shared network hard
drive, so they can still be opened okay on the old
computer. The user however now only has access to this new
computer with Windows XP Pro and Office XP SBE SP2, and
that is where the calculation problems show up. Any help
would be greatly appreciated. Thank you.

 

[immanuel]

What functions is your customer using in the cells that don't recalculate?

Check out:
242237.KB.EN-US XL: Worksheet May Not Recalculate Completely When You
Repeatedly Press F9
215732.KB.EN-US XL2000: Formula Using SUMIF() Worksheet Function Does Not
Recalculate Sum
200688.KB.EN-US XL2000: Inconsistent Results Using Natural Language Formulas
231000.KB.EN-US XL2000: COUNTIF Returns Incorrect Value When It Refers to
Blank Cells

/i.