Microsoft Word for Windows
If you copy information from a worksheet when the name contains an
exclamation point and click
Paste Special in a document in Microsoft Word, the following options are available in the
As list:
Microsoft Excel Worksheet Object
Formatted Text (RTF)
Unformatted Text
Picture
Bitmap (Windows version only)
If you click
Formatted Text (RTF) and click
Paste Link, the following error message appears when you click
OK:
Word cannot obtain the data for the Microsoft Excel Worksheet link.
If you select any of the other available options, and click
OK with
the
Paste Link option selected, the worksheet information appears in
the Word document. However the information is not updated when you
change the data in Microsoft Excel.
In Microsoft Excel, if you select any of the options in the
Paste
Special dialog box and click
Paste Link in Word, the following
error message appears:
Word cannot obtain the data for the Microsoft Excel Worksheet link.
Microsoft Write (Windows Only)
If you copy information from a worksheet when the name contains an
exclamation point, and click Paste Special in a document in Microsoft
Write, the following options are available in the
Data Type list:
Microsoft Excel Worksheet Object
Picture
Bitmap
Text
The
Paste Link button is not available when you click the
Text option.
Note that this problem occurs even if the worksheet name does not
contain an exclamation point.
If you click any of the other options and click
Paste Link, the
information appears in the Microsoft Write document. However, the
information is not updated when you change the source information. When
you edit the link in Microsoft Write, you receive the following error
message:
Linked document is unavailable.
When you update the link using the
Links dialog box, you receive the
following error message:
The source document cannot be found.
Make sure that the object still exists in the source document, the
link is uncorrupted, and the source document is still available
(that is, it has not been deleted, moved, or renamed).