N/APosted on - 08/28/2011
I have this problem encountered on Microsoft Excel. Everytime I input a figure for summation, the cell is not returning a value. What it returns is the same value of previous data. The SUM function only works when I click on the SAVE button.
Is there any way this can be corrected?
You may have done my foregoing instructions but just read through them, you might have missed something.
Set workbook calculation to "automatic".
From Microsoft Excel, go to Tools -> Options… -> click on "Calculation" tab.
Under the "Calculation" section, make sure that the radio button for "Automatic" is enabled.
The screenshot below is for Excel 2010. But the basic procedure remains the same for all past and present versions of Microsoft Office.
Automatic calculation is what you supposed to use. That is, Excel performs calculation immediately after a variable in the formula changes. Your settings probably changed because the Excel file that you are editing was saved from a computer whose Excel was not set to automatic calculation.
Hope this helps!