Excel not updating
To use formulas efficiently, there are three important considerations that you need to understand: Calculation is the process of computing formulas and then displaying the results as values in the cells that contain the formulas.To avoid unnecessary calculations that can waste your time and slow down your computer, Microsoft Excel automatically recalculates formulas only when the cells that the formula depends on have changed.This is the default behavior when you first open a workbook and when you are editing a workbook.However, you can control when and how Excel recalculates formulas.Both commands use iteration in a controlled way to obtain desired results.
If you set the cell to a number format so that all digits are shown (instead of a scientific format, such as 1.23457E 06), you'll see that the number is displayed as 1234567.890123450.
Also, the calculation process may take more time if the worksheets contain links to other worksheets or workbooks.
You can control when calculation occurs by changing the calculation process to manual calculation.
If you add the two cells together, the result is .01 because Excel adds the stored values 10.005 and 10.005, not the displayed values.
When you change the precision of the calculations in a workbook by using the displayed (formatted) values, Excel permanently changes stored values in cells from full precision (15 digits) to whatever format, including decimal places, is displayed.
To cancel updating the link and use the previous value obtained from the source worksheet, click Cancel.