| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 does not automatically calculate
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Excel to automatically calculate the value of a hyper | Excel Worksheet Functions | |||
| Excel calculate the z factor automatically | Charts and Charting in Excel | |||
| Excel calculate the z factor automatically | Charts and Charting in Excel | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| how to calculate overtime automatically on Excel timesheets | Excel Worksheet Functions | |||
Linear Mode
