Troubleshoot linked objects and embedded objects

ShowWhen I double-click a linked object or embedded object, a "cannot edit" message occurs.

This message appears when the source file (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) or source program (source program: The program used to create a linked object or embedded object. To edit the object, you must have the source program installed on your computer.) can't be opened.

  • Make sure the source program is installed on your computer. If the source program is not installed, convert the object to the file format of a program that is installed.

ShowHow?

  1. Select the linked (linked object: An object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.) or embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.) you want to edit.
  2. On the Edit menu, point to Linked object name Object for a linked object (for example, Linked Worksheet Object) or object name Object for an embedded object (for example, Worksheet Object), and then click Convert.
  3. Select the new file type in the Object type box.
  4. Select whether to convert the object you specified in the Object type box or open it as a specific object type:
    • To convert the embedded object, click Convert to.
    • To open the embedded object without changing the embedded object type, click Activate as.

ShowI want the object rather than an icon to appear in my document.

  1. Click the icon.
  2. On the Edit menu, point to Linked object name Object for a linked object (for example, Linked Worksheet Object) or object name Object for an embedded object (for example, Worksheet Object, and then click Convert.
  3. Clear the Display as icon check box.

ShowIn my document, large linked or embedded objects are cropped.

When you create a large linked object (linked object: An object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.) or embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.), it may be cropped on the right or bottom side — even if there is enough room to fit the entire object on the page. This occurs because Microsoft Word displays the linked or embedded object's Extended metafile (EMF) presentation, which has a maximum height and width. If your object exceeds this maximum size, it appears cropped in the Word document.

To prevent a linked or embedded object from being cropped, do one of the following:

ShowI can't open an Excel object from Word.

  1. Switch to Microsoft Excel.
  2. On the Tools menu, click Options, and then click the General tab.
  3. Clear the Ignore other applications check box.

ShowAfter I save my Excel worksheet in Word, I can't open it in Excel.

In Microsoft Word, you can import a Microsoft Excel worksheet or range by opening the workbook it's stored in. However, in Word you can't save the worksheet in Excel format. If you save the worksheet in Word format, Excel can no longer read the worksheet (or the workbook that contains the worksheet).

To edit and save changes to an Excel worksheet, don't save it in Word. Instead, open the worksheet in Excel, and then edit it and save your changes. Then, you can open the worksheet again in Word.

ShowI can't find the Select method check box.

The Select method check box has been replaced. On the Tools menu, click Options, and then click the General tab. Select or clear the Confirm conversion at Open check box. When you select the check box, the Confirm Data Source dialog box opens when you open a data source.

 
 
Applies to:
Word 2003