microsoft excelmicrosoft-excel-2003
I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when the cells are clicked out of.
However, for some reason, the value calculated by the formula does not update automatically. I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing.
Why is this happening?
You have "Text"-type formatting chosen.
I believe this has a tendency to "leak over" if adjacent cells have it.
It is an automatic formatting option, but please don't ask me how to turn it off.
Select the cell you have trouble with, then press CTRL+1 (Menu: Format > Cells)
Select "General" (in Excel) or "Category: All, Format: General" (LibreOffice)
... in the dialog that appears.
NOTE: You need to re-edit the cell too... (select the cell, hit F2 and then hit ENTER)
To reset ALL CELLS click the rectangle upper left - above [ 1 ] and left of [ A ] - then reset it the same way as above, the last step is a bit cumbersome :-I .
The quickest way to do this is to paste your formula into required cells then highlight them by selecting the column and then click the "Calculate Now" button:
This will update the results of the formulae.
If this used to work then it could be that the calculation options have been set to manual. Click on the menu and select "Automatic":
Best Answer
A likely cause is that Calculation is set to manual. To change this to automatic in the various versions of Excel:
2003: Tools > Options > Calculation > Calculation > Automatic.
2007: Office button > Excel options > Formulas > Workbook Calculation > Automatic.
2010 and newer: File > Options > Formulas > Workbook Calculation > Automatic.
On Mac:
In some cases you may prefer to keep it set to manual, for example if there are many heavy calculations to perform. In such cases, you can simply press F9 when you want the calculations to update.