Microsoft KB Archive/290148

= How to use the Undo feature with inserted objects in Office programs =

Article ID: 290148

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office PowerPoint 2007
 * Microsoft Office PowerPoint 2003
 * Microsoft PowerPoint 2002 Standard Edition
 * Microsoft Office Word 2007
 * Microsoft Office Word 2003
 * Microsoft Word 2002 Standard Edition

-



This article was previously published under Q290148



For a Microsoft Office 98 version of this article, see 183279.

For a Microsoft Office 97 version of this article, see 172542.

IN THIS TASK
SUMMARY How to Use the Undo Feature with Inserted Objects
 * Microsoft Word Document Objects
 * Microsoft Excel Worksheet Objects and Chart Objects
 * Microsoft PowerPoint Presentation Objects
 * Microsoft Access Database Objects

Example REFERENCES



SUMMARY
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.

back to the top

How to Use the Undo Feature with Inserted Objects
Each 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:
 * For Office 2003 or earlier versions, click Undo on the Edit menu.
 * For Office 2007 or earlier verions, click the Undo button on the Quick Access Toolbar.

When you click the arrow next to the Undo button on the toolbar, you can see a list of the actions that you performed. This list is called the &quot;undo stack.&quot; Usually, the undo stack is cleared only when you perform an irreversible action, such as when you close a file. When you reopen the file, no items are listed in the undo stack.

However, when you insert an object into another program, the undo stack may be cleared when you deactivate and reactive the object.

back to the top

Microsoft Word Document Objects
When 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.

back to the top

Microsoft Excel Worksheet Objects and Chart Objects
When 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.

back to the top

Microsoft PowerPoint Presentation Objects
When 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.

back to the top

Microsoft Access Database Objects
You cannot insert a Microsoft Access database object into another program.

back to the top

Example
The following example demonstrates the behavior of the undo stack when you insert an Excel worksheet object into a Word document:
 * 1) Start Word, and then create a new document.
 * 2) In Word 2003 or earlier versions, click Object on the Insert menu.

In Word 2007, on the Insert tab, click Object.
 * 1) In the Object type list, click Microsoft Excel Worksheet, and then click OK.
 * 2) In the Excel worksheet object, type values in some of the cells. When you finish typing, click any cell in the worksheet object.
 * 3) Click the arrow next to the Undo button on the toolbar.

Note that the list contains several items, such as Typing ' ' in , where   is the value that you typed and   is the cell that contains the value.
 * 1) Deactivate the worksheet object. To do so, click an empty area of the Word document.
 * 2) Reactivate the worksheet object. To do so, double-click the worksheet object.
 * 3) Click the arrow next to the Undo button on the toolbar.

Note that the list displays only one item, which is named Last.

If you perform these same steps when you use a Microsoft PowerPoint presentation object, the behavior is the same. That is, the undo stack is cleared.

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.

back to the top

Additional query words: OfficeKBHowTo inf

Keywords: kbexpertisebeginner kbhowtomaster kbinterop KB290148

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.