excel 2007 does not automatically calculate

[maxvista]

I am new here, and I need help please.
I have an excel worksheet that I use to update my daily fiancials.
Just recently for some reason when I enter a number, excel does not sum up
directly. Considering that I have been using this same worksheet for a year
now and never had this problem before.
I have to click on the formula and press enter for it to update.

Not sure if I disabled something in excel 2007.

THanks

 

[trip_to_tokyo]

In EXCEL 2007 try this:-

Office Button (top left hand corner)

Excel Options

Formulas (on left hand side)

In here make sure that:-

Workbook Calculation

- towards the top is set to Automatic.

If my comments have helped please hit Yes.

Thanks.