Function quit working

  • Thread starter Thread starter Kari
  • Start date Start date
K

Kari

I have an excel form that I have used for over 2 years now. One of the cells
has a sum function which adds 7 other cell values together. It stopped
adding. I re-typed the formula into the cell and it added as it should.
However, when I change a value in one of the 7 cells, the function will not
recalculate the sum. This is now the case within the entire workbook. Non
of the sum functions work.

Does anyone have any ideas? Thank you,
 
Make sure the calculation option did not somehow get changed to manual.
Prior to 2007, the menu path would be Tools|Options|Calculation.

Jerry
 
Thank you so much. Changing the calculation option from manual to automatic
fixed my problem. In Excel 2003 Tools|Options|Calculation was the correct
place to find and fix the calculation option.
 
Back
Top