The information in this article applies to:
- 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 Word for the Macintosh versions 6.0, 6.0.1, 6.0.1a
- Microsoft Excel for Windows, versions 4.0, 4.0a
- Microsoft Excel for Windows 95, versions 5.0, 5.0a, 5.0c
- Microsoft Excel 97 for Windows
- Microsoft Excel for the Macintosh, versions 5.0, 5.0a
SUMMARY
If you copy a selection from a Microsoft Excel spreadsheet, switch to
Word, choose Paste Special from the Edit menu, and choose Microsoft
Excel Worksheet Object, the Paste Link option is available.
Choosing to paste link a Microsoft Excel worksheet object in a Word
document gives you the same result as paste linking the Picture format.
This behavior is different than previous versions of Word, which did
not allow the Paste Link option while Microsoft Excel Worksheet Object
is selected.
This information applies to any data that is copied from an program
that supports object linking and embedding (OLE). Some applications
that claim to support OLE may only support embedded objects.
MORE INFORMATION
The differences between the Paste Special options are as follows:
- An embedded Microsoft Excel object (with no link) is created when
you choose Microsoft Excel Worksheet Object in the Paste Special
dialog box and select the Paste option. An EMBED field is inserted
into your document. You can change the information in the object
by double-clicking the object, which launches Microsoft Excel with
a COPY of the original spreadsheet and allows you to modify the
data as it appears in Word. The "native" Microsoft Excel data, used
by Microsoft Excel when editing, is stored in your Word document.
The original spreadsheet, if it was ever saved to a Microsoft Excel
file, is not affected.
- A linked (NOT embedded) object is created when you select any of
the available formats and choose Paste Link. Word inserts a LINK
field to represent the linked object. The \a switch is inserted
into the field to indicate automatic update.
LINK fields can have the following format switches:
Switch Description
------------------------------------------
\a Updates the LINK field automatically
(delete the \a switch for manual updating)
\b Inserts the linked object as a Bitmap
\d Graphic data is not stored with the document,
reducing the file size.
\p Inserts the linked object as a Picture
\r Inserts the linked object in rich-text format
\t Insert the linked object in text-only text
All formats except Picture (\p) are inserted with a \*MERGEFORMAT
switch. When this switch is added to a LINK field, the font size
and style, borders, and dimensions of the object do not change to
match the formatting in the source Microsoft Excel spreadsheet when
you update the object.
Updating the text in the original spreadsheet updates the linked
information in your Word document. If you modify the information in
the Microsoft Excel spreadsheet while the Word document is closed,
Word will automatically update the sheet when you open your
document. To disable this feature, choose Options from the Tools
menu, select the General tab, and clear Update Automatic Links at
Open. You can then update individual objects by selecting the
object and pressing F9.
- When you select Microsoft Excel Worksheet Object and choose Paste
Link, you get the same result as if you had chosen Picture and
Paste Link: a LINK field with the \a and \p switches. As with any
linked object, you can double-click it to modify it. This will load
and modify the ORIGINAL spreadsheet (.xls file). Changes will be
displayed in your Word document.
|