XL5: Can't Edit or Activate Copy Picture Link from Excel

Last reviewed: September 12, 1996
Article ID: Q113988

The information in this article applies to:

Microsoft Excel for Windows, version 5.0
Microsoft Word for Windows, versions 6.0, 6.0a
Microsoft Project for Windows, version 4.0
Microsoft Access, version 2.0
Microsoft Write, versions 3.1, 3.11

SYMPTOMS

In Microsoft Excel, when you use the Copy Picture command in an unsaved workbook, and you link this information to another application, the linked information is not updated, and you receive an error message when you activate or edit the linked object.

WORKAROUND

To avoid this behavior when you link picture information from Microsoft Excel to another application, do any of the following:

Link the information in the Microsoft Excel workbook as a picture using the following steps:
1. In Microsoft Excel, copy the information you want to link to another
```
      application (do not use Copy Picture).
```
2. In the document to which you want to link the information, choose
```
      Paste Special from the Edit menu.
```
3. Select the Paste Link option. From the As box, select Microsoft Excel
```
      5.0 Worksheet Object (or Picture) and choose OK.
```
-or-
Save the workbook in Microsoft Excel before you use the Copy Picture command.
-or-
If you have already used the Copy Picture command and linked information from an unsaved workbook, do the following to fix the link:
1. In Microsoft Excel, save the workbook that contains the information
```
      that you want to link.
```
2. In the document that contains the linked information, choose Links
```
      from the Edit menu.
```
3. From the Source File list, select the link. Choose the Change Source
```
      button. From the File Name list, select the name of the file you
      saved in Step 1 and choose OK. The link is now re-established.
```

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The following table shows the error messages that may appear when you use the Copy Picture command on a Microsoft Excel worksheet, and you select the Paste Link option in the Paste Special dialog box of the application to which you want to paste the information.

   Application        Error Message
   -----------------  ------------------------------
   Microsoft Word     Word cannot edit the Microsoft
                      Excel worksheet

   Microsoft Project  Cannot open linked document

   Microsoft Write    Linked document is unavailable

   Microsoft Access   A file needed to complete the
                      operation could not be opened

Note that when you use the Copy Picture command in Microsoft Excel, and you choose Paste Special in a Microsoft PowerPoint slide, the Paste Link option is not available.

KBCategory: kbole kbinterop kberrmsg
KBSubcategory:
Additional reference words: 2.00 4.00 5.00 6.00 officeinterop ole
macppt winppt linking embedding

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.