Insert information by creating a linked object or embedded object

You can create a 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.) from any program that supports linked objects and embedded objects.

Linked and embedded objects in a document

Callout 1 Embedded object
Callout 2 Linked object
Callout 3 Source file

ShowCreate a new embedded object

  1. Click in the document where you want to place the embedded object.
  2. On the Insert menu, click Object, and then click the Create New tab.
  3. In the Object type box, click the type of object you want to create.

Only programs that are installed on your computer and that support linked objects and embedded objects appear in the Object type box.

  1. To display the embedded object as an icon — for example, if you want to minimize the amount of space the object uses in the document — select the Display as icon check box.

 Note   You can also insert a Microsoft Excel worksheet as an embedded object by clicking Insert Microsoft Excel Worksheet Button image on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.).

Create a linked object or embedded object with existing information

ShowFrom a Microsoft Excel file

  1. Open both the Microsoft Word document and the Microsoft Excel worksheet that contains the data you want to create a linked object or embedded object from.
  2. Switch to Microsoft Excel, and then select the entire worksheet, a range of cells (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.), or the chart you want.
  3. Click Copy Button image.
  4. Switch to the Word document, and then click where you want the information to appear.
  5. On the Edit menu, click Paste Special.
  6. To link or embed the object, do one of the following:
    • To create a linked object, click Paste link.
    • To create an embedded object, click Paste.
  7. In the As box, click the entry with the word "object" in its name. For example, click Microsoft Excel Worksheet Object.

 Note   If you link data from a worksheet and select the Keep Source Formatting and Link to Excel option, the linked data will match the formatting in the Excel 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.). If you select the Match Destination Table Style and Link to Excel option, the linked data will be formatted in the Word default table style.

With either option you can change the formatting of the linked object in the Word document. Formatting changes you make will remain when the data is updated in the source file.

ShowFrom other program files

  1. Open the file that contains the information you want to create a linked object or embedded object from, and then select the information.
  2. Click Copy Button image.
  3. Switch to the Microsoft Word document, and then click where you want the information to appear.
  4. On the Edit menu, click Paste Special.
  5. To link or embed the object, do one of the following:
    • To create a linked object, click Paste link.
    • To create an embedded object, click Paste.
  6. In the As box, click the entry with the word "object" in its name. For example, click Microsoft Word Document Object.

ShowFrom an entire file

  1. Click in the document where you want to place the linked object or embedded object.
  2. On the Insert menu, click Object.
  3. Click Create from file.
  4. In the File box, type the name of the file you want to create a linked object or embedded object from, or click Browse to select from a list.
  5. To create a linked object, select the Link to file check box.

An embedded object is created if you don't select the Link to file check box.

  1. To display the linked object or embedded object as an icon — for example, if you want to minimize the amount of space the object uses in the document — select the Display as icon check box.

 Note   When you create an embedded object from information in an existing Microsoft Excel workbook, the entire workbook is inserted into your document. The document displays only one worksheet at a time. To display a different worksheet, double-click the Microsoft Excel object, and then click a different worksheet.

 
 
Applies to:
Word 2003