WD: After Update Excel Object Not a Paste Special OptionLast reviewed: February 2, 1998Article ID: Q78580 |
The information in this article applies to:
SYMPTOMSWhen you run Microsoft Excel as an OLE server application, in some cases, you will be unable to paste an Excel object into Word using the Paste or Paste Special commands on the Edit menu. If you click Paste Special, the Source field in the Paste Special Dialog box will specify that the source is unknown.
CAUSEThis behavior occurs because the Excel object is no longer in the Clipboard. When you run Microsoft Excel as an OLE server application with Microsoft Word, after you update the embedded Excel object and return to Word, the Excel object disappears from the Clipboard.
WORKAROUNDTo use the Paste Special command to embed an Excel object in your Word document as many times as you like, follow these steps:
MORE INFORMATIONIf you embed an Excel worksheet object in Word by choosing Object from the Insert menu and selecting one of the Excel object options (or if you edit an already embedded Excel object) you activate an Excel server session. To quit the Excel server session and return to the Word document, click Update on the File menu and then click Exit. When you quit Excel, the Excel object in the Clipboard is deleted from the Clipboard. Because the Clipboard no longer contains the Excel object, the Excel Object options are not available in Paste Special.
REFERENCES"Microsoft Word for Windows User's Guide," version 2.0, pages 690-695
|
Additional query words: object linking and embedding
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |