Excel sum not updating
When enabling this option, you will receive a warning message in Excel indicating the “Data Will Permanently Lose Accuracy.” The nature of this message is that Excel will permanently round and truncate the data to the current number of decimal places in the cell format, so be sure to make a backup of the workbook before you enable the option if you are unsure about the consequences of enabling Precision As Displayed.
While you cannot change how Excel handles floating point calculations, you can control how the results of these types of calculations appear in your spreadsheets.
But if I edit D2 and I press SPACE (so I modify the D2 VALUE ) Calc can calculate the good value.
F9 works but I think I should not have to use F9 all the time.
To activate Precision As Displayed in Excel 2007, click the Office Button, Excel Options, and Advanced.
Scroll down the list until you reach the option labeled Set precision as displayed and check the corresponding box.
Consider the set of data in cells A1 through A3 of Figure 1.
Following the example shown in Figure 1, entering the formula =ROUND(SUM(A1: A3),2) into cell A4 produces the anticipated result of zero as shown in Figure 3.
In binary format, some numbers simply cannot be stored with perfect accuracy.
As such, even though a number appears to be one value, it might actually be rounded when it is stored.
In Excel 2010, activate the option by clicking the File tab, Excel Options, and Advanced.
Then scroll down the list and check the box next to Set precision as displayed.