math formulaes arent working in excel

[Russ Johnson]

I use a spreadsheet to keep track of sick and vacation days and the
spreadsheet math seems to have stopped working. These are very simple
addition and subtraction formulae's and I don't see anything out of the
ordinary.

 

[Niek Otten]

Hi Russ,

What do you mean: "stopped working"?
What happens? What do you see? What did you expect to see?

Check:

Tools>Options>Calculation tab>Automatic


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I use a spreadsheet to keep track of sick and vacation days and the
| spreadsheet math seems to have stopped working. These are very simple
| addition and subtraction formulae's and I don't see anything out of the
| ordinary.
| --
| Russ Johnson

 

[Mike H]

Try

Tools|Options|calculation

select Automatic
Click Ok
Tap F9

Mike

 

[Reitanos]

As Niek has said, automatic calculation may be turned off, so that
Excel will not perform calculation until prompted.

Another common problem that presents itself this way is when another
user accidentally replaces formulas with values by typing over them.