math formulaes arent working in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russ Johnson - 02 May 2008 21:09 GMT

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.

Signature

Russ Johnson

Reply to this Message

Niek Otten - 02 May 2008 21:14 GMT

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

Signature

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.

Reply to this Message

Mike H - 02 May 2008 21:19 GMT

Try

Tools|Options|calculation

select Automatic
Click Ok
Tap F9

Mike

> 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.

Reply to this Message

Reitanos - 02 May 2008 21:27 GMT

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.

On May 2, 4:09 pm, Russ Johnson
<RussJohn...@discussions.microsoft.com> wrote:

Reply to this Message