Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Linking and Embedding Objects

Information created using other Office programs can be shared among them. This means that data created in an Office document, and can be included in a Excel worksheet without being retyped. This makes projects such as annual or departmental reports simple to create. Information can be either linked or embedded. Data that is linked has the advantage of always being accurate because it is automatically updated when the linked document is modified.

Create a Link to Another File

  • yellow-circle-01.gif Open the source file and any files containing information you want to link.
  • yellow-circle-02.gif Select the information in the source file.

  • yellow-circle-03.gif Click the Edit menu, and then click Copy.
  • yellow-circle-04.gif Click the insertion point in the file containing the link.
  • yellow-circle-05.gif Click the Edit menu, and then click Paste Special.
  • yellow-circle-06.gif Click Paste Link.

Embed a New Object

  • yellow-circle-01.gif Click the Insert menu, and then click Object.
  • yellow-circle-02.gif Click the object type you want to insert.
  • yellow-circle-03.gif To display the object as an icon, select the Display as icon check box.
  • yellow-circle-04.gif Click OK.

  • yellow-circle-05.gif Follow the necessary steps to insert the object.

    The steps will vary depending on the object type.

Embed or Link to an Existing Object

  • yellow-circle-01.gif Click the Insert menu, and then click Object.
  • yellow-circle-02.gif Click From File.
  • yellow-circle-03.gif Click the Where drop-down, and then select the location that contains the file you want.
  • yellow-circle-04.gif Select the file that you want to link.
  • yellow-circle-05.gif To create a link to the object, select the Link to File check box.
  • yellow-circle-06.gif To display the object as an icon, select the Display as icon check box.
  • yellow-circle-07.gif Click OK.

  • + Share This
  • 🔖 Save To Your Account