Hi ptree,

Go to Tools Options Calculations and check automatic.

HTH
cwilson

"ptree" wrote:

I have formulas in certain cells on a spreadsheet. When I change one of the
values within one of the cells, the sum does not change until I go up to the
formula bar on top and click on the check mark. This has never happened
before so I must have hit some control button. I want my sums to change
automatically when I change a cell value.