WD: After Update Excel Object Not a Paste Special Option (78580)
The information in this article applies to:
- Microsoft Word for Windows 2.0
- Microsoft Word for Windows 2.0a
- Microsoft Word for Windows 2.0b
- Microsoft Word for Windows 2.0c
- Microsoft Word for Windows 6.0
- Microsoft Word for Windows 6.0a
- Microsoft Word for Windows 6.0c
- Microsoft Word for Windows 95
- Microsoft Word for Windows 95 7.0a
- Microsoft Word for the Macintosh 6.0
- Microsoft Word for the Macintosh 6.0.1
- Microsoft Word for the Macintosh 6.0.1a
- Microsoft Word 98 Macintosh Edition
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q78580 SYMPTOMS
When 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.
CAUSE
This 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.
WORKAROUND
To use the Paste Special command to embed an Excel object in
your Word document as many times as you want, follow these steps:
- Start Excel independent of Word (do not run it as a server
application).
- Copy the Excel selection you want to appear in your Word document
(do not quit Excel).
- Start Word.
- On the Edit menu, click Paste Special.
Note that the Excel object remains an available option in the Paste
Special dialog box until you quit Excel or replace the contents of the
Clipboard with something else.
MORE INFORMATION
If 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.
| Modification Type: | Minor | Last Reviewed: | 8/16/2005 |
|---|
| Keywords: | kbhowto kbinterop KB78580 |
|---|
|