excel 2007 does not automatically calculate

  • Thread starter Thread starter maxvista
  • Start date Start date
M

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