Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Undo Does Not Always Restore Previous Value


View products that this article applies to.

This article was previously published under Q211573

↑ Back to the top


Symptoms

After you use the Undo command, a cell value that you changed may not return to its previous value.

↑ Back to the top


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 another 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, 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.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


More information

Microsoft Excel allows 16 levels of undo operations. You can reverse an action by clicking Undo on the Edit menu or by clicking the Undo button on the Standard toolbar.

↑ Back to the top


Keywords: KB211573, kbusage, kbpending, kbualink97, kbbug

↑ Back to the top

Article Info
Article ID : 211573
Revision : 3
Created on : 9/25/2003
Published on : 9/25/2003
Exists online : False
Views : 250