Function quit working

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,
 
J

Jerry W. Lewis

Make sure the calculation option did not somehow get changed to manual.
Prior to 2007, the menu path would be Tools|Options|Calculation.

Jerry
 
K

Kari

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
Excel 2003 BOM Cost roll-up Function 1
Set add function ignore #N/A 1
Excel Sum numbers in cells that also contain text 34
How to force all cell contents in a column to be a number? 1
Why does Excel "sum" function work correctly only intermittently? 1
0.820000000000001 instead of 0.82 1
formula to make the value in a cell, to a row in a sum function 5

Top