XL97: Undo Does Not Always Restore Previous Value

CAUSE

This behavior occurs when the cell contains dependencies or formulas that require recalculations. This behavior may occur in the following cases.

Case 1

When a cell is dependent on other cell for a value, Microsoft Excel may not update the dependency dynamically until it is forced to do so. Undoing an entry that is a precedent to another cell does not force the link to update to its previous value.

Case 2

When you turn on manual calculation, link one cell to another, and then use the Undo command, Microsoft Excel does not force the link to update to its previous value.

Case 3

When a cell contains a formula that uses a function that refers to another cell (for example, the RAND function), the cell does not revert back to its previous value when you use the Undo command to undo the value of its precedent.