Go to Tools-Options-Calculation and set it to Automatic. Save you workbook.

This is a flakey setting and, even after you change it, opening a workbook
saved with Manual re-calc sets all open workbooks to Manual, too.


"Q" wrote:

Additonal note: I just figured out that when I do a manual "save" it also
causes the forula to recalcualte....

"Q" wrote:

Ihave a workbook with about 20 tabs. I use it to track bank accounts,
stocks, etc. I have used it for about 18months. Recently it has quit
calculating the formula's in each tab. For example I have one tab that is
like a check register and it add/subtracts entries in a balance column. When
I enter a check, the balance cell does not change. I have found that if I
open the cell that is not calculating and overtype a letter or number and
then hit enter, it then calculates. I have checked to make sure the cells
are not text, they are eithyer number or currency.