Link to object

 
Word can collect data from another program (eg Excel, or PowerPoint) by linking it to insert or embed.
This data is called an object.
We use a linked file as the data to be automatically updated when we make changes to the linked file, or when we take into account the size of the target file.

In contrast to a linked object, an object is embedded as a part of the target file. Because an embedded object has no links to the source file, it will not be updated when the data changes.

In this example, I insert a file from Excel.
So for clarity, the Word file is the target file, and the Excel file is the source file.

First place the cursor in your document where you want to insert the object.
Click the button “Object” under the tab “Insert” in the ribbon.
And click the “Object” in the drop-down menu.
This opens the dialog “Object”.
I want to insert an existing Excel file, so I click on the tab “Create from File”.
And click the button “Browse” to navigate to the file that you want to insert.
I select the file, and click the button “Insert”.

The file is placed on my computer, filled with the “Filename”.

Then I decide if I want to link the file or insert.
Check the box “Link to file” to attach the Excel file to Word document, check this box on, then get the Excel file we inserted into a Word document.

When we enter the second compartment (as icon) is checked, an icon is only shown in our paper, that when we double click it, we open the file in the application. But this is more something of the previous lesson “Create hyperlinks to other files.”

In this example I’m checking the option “Link to file”.
And click the OK button.
This executes the file completely in our Word Document.

Do you want only part of an Excel file to insert, do the following.
Open the Excel file.
In the Excel file, select the section you want to link with the Word document.
Click the button “Copy”.
Go to the Word document.
And click the button “Paste” in the ribbon.
From the drop-down menu choose the option “Paste Special”.
This opens the dialog “Paste Special”:

Select “Microsoft Office Excel Worksheet Object”, and click OK.
This executes only the data from the Excel document that I have selected.
When the change data in the Excel Workbook, they are automatically updated in the Word document.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats