View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default excel 2007 does not automatically calculate

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.


"maxvista" wrote:

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