WD: Changes to Microsoft Excel Object Not Saved in Word

ID: Q140345

The information in this article applies to:

• Microsoft Word for the Macintosh, versions 6.0, 6.0.1
• Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
• Microsoft Word for Windows 95, versions 7.0, 7.0a
• Microsoft Word 97 for Windows
• Microsoft Excel for Windows, version 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, version 5.0

SYMPTOMS

Changes you make to an embedded Microsoft Excel object are not saved when you quit Microsoft Excel. This problem occurs when you edit a Microsoft Excel object that has been embedded by clicking Object on the Insert menu or by using the "Insert Microsoft Excel Worksheet" button on the toolbar.

WORKAROUND

To ensure that the changes you make to an edited Microsoft Excel object are saved, do one of the following:

• Type the information you want in the embedded object, and then press the ENTER key or the TAB key. The insertion point moves to the next cell. Press CTRL+S to save the value in the embedded object, and then click outside of the worksheet to return to Word. This will update the object.
• After editing the Microsoft Excel object, press CTRL+S, and then click outside of the worksheet to return to Word. This will update and save the object.

STATUS

Microsoft has confirmed this to be a problem in the products listed at the beginning of this article.

Additional query words: Excel update change edit embedded ole

Keywords          : kbinterop kbole winword macword word6 word7 word95 macword5 macword6 
Version           : WINDOWS:6.0,6.0a,6.0C,7.0,7.0a;MACINTOSH:6.0,6.0.1,6.0.1a
Platform          : MACINTOSH WINDOWS
Issue type        : kbbug kbhowto
Solution Type     : kbfix

Last Reviewed: January 21, 1999