Article ID: 290148 - View products that this article applies to.
This article was previously published under Q290148
When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and then you deactivate and reactivate the inserted object, the Undo command may behave differently in each program. This article explains the differences in the behavior of the Undo command with inserted objects in Microsoft Office programs.
How to Use the Undo Feature with Inserted ObjectsEach Office program includes an Undo command. When you use this command, you can undo certain actions after you perform them. For example, if you type a value in an Excel worksheet cell, you can undo the action. To use the Undo command, do either of the following:
However, when you insert an object into another program, the undo stack may be cleared when you deactivate and reactive the object.
Microsoft Word Document ObjectsWhen you insert a Microsoft Word document into another program, make changes to the document, deactivate the document object, and then reactivate the document object, the undo stack is not cleared. As a result, you can still undo changes that you previously made to the Word document object.
Microsoft Excel Worksheet Objects and Chart ObjectsWhen you insert an Excel worksheet object or chart object into another program, make changes to the worksheet, deactivate the worksheet object, and then reactivate the worksheet object, the undo stack is cleared. You cannot undo changes that you previously made to the Excel worksheet or chart object.
Microsoft PowerPoint Presentation ObjectsWhen you insert a PowerPoint presentation object into another program, make changes to the presentation, deactivate the presentation object, and then reactivate the presentation object, the undo stack is cleared. You cannot undo changes that you previously made to the PowerPoint presentation object.
Microsoft Access Database ObjectsYou cannot insert a Microsoft Access database object into another program.
ExampleThe following example demonstrates the behavior of the undo stack when you insert an Excel worksheet object into a Word document:
If you insert a Word document object into another program, deactivate and then reactivate the document object, the undo stack is not cleared. The Undo list contains all of the same items after you reactivate the document object.
Article ID: 290148 - Last Review: November 21, 2006 - Revision: 4.2