Unexpected Results with Second Paste Link to Item

ID: Q111904

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

SYMPTOMS

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.

CAUSE

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.

WORKAROUND

To work around this problem, do any of the following:

If you linked information in an undesired format, delete this linked information first before linking again in another format.

Link the information using one format. Then copy the information from the other application again and include an extra space or character that will not be noticeable when you create the link. Because the information you copy is different, Microsoft Excel correctly uses the format you choose to link.

Note that you can always use the Paste option in the Paste Special dialog box for the same information using any available format. This problem occurs only when you choose the Paste Link option.

STATUS

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.

Additional query words: 2.00 4.00a 6.00 6.00a officeinterop macppt winppt

Keywords :
Version : 4.00 4.00a 5.00
Platform : WINDOWS
Issue type :