ID: Q111904
4.00 4.00a 5.00 WINDOWS kbole BUGLIST5.00 FIXLIST5.00C
The information in this article applies to:
In Microsoft Excel, if you use the Paste Link option in the Paste Special dialog box to link information from another application as an object or picture, and then link the same information as text, the link as text appears on the worksheet as follows:
#VALUE!
In addition, if you link information from another application as text, and
then link the same information as an object or picture, the object or
picture appears to be blank.
If you link the same information using different formats, only the first format is used in Microsoft Excel. For example, if you link information from another application as a picture, then link the same information as Text, the picture format is used. Because the picture format cannot be displayed as text, #VALUE! appears in the cell in which you pasted the information.
To work around this problem, do any of the following:
-or-
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows version 5.0c.
KBCategory: kbole KBSubcategory:
Additional reference words: 2.00 4.00 4.00a 5.00 6.00 6.00a officeinterop macppt winppt
Version : 4.00 4.00a 5.00
Platform : WINDOWS
Last Reviewed: September 14, 1996