Ms excel cells not updating
Upon doing so, Excel changes all of the formulas in the column.
Immediately click the Undo button on the Quick Access Toolbar or use the CTRL Z keyboard shortcut and you will notice that all of the other formulas return to their original state and that the formula in the cell of interest is now different from all of the other formulas in that column.
In the Auto Correct dialog box, uncheck the box next to Fill formulas in tables to create calculated columns and click OK.
This problem often arises because the cells containing the formula are formatted as 'text' instead of the 'General' type.
As you have learned in this tip, you can easily do this by using Excel’s Undo feature or, more broadly, disabling this feature in Excel’s Options.
For a video demonstration of this tip, please visit
If you want to disable formula replication altogether, you can do that by changing one of Excel’s Options.
In the Excel Options window, choose Proofing and then click the Auto Correct Options button to open the Auto Correct dialog box.