Excel, Linking and Embedding (Lesson 6-WWS)
What are the steps to link Excel data or chart in a Word document to the Excel source file?
1. Select and copy the data or chart in the Excel worksheet. 2. Switch to the Word file and click in the location where the data (or chart) is to be printed. 3. In the Home tab, click the Paste button arrow, then click Paste Special. 4. Click the Paste Link button, then click Microsoft Excel Worksheet Object or Chart Object, and then click OK.
What are the steps to embed Excel data or chart into a Word document?
1. Select and copy the data or chart in the Excel worksheet. 2. Switch to the Word file and click in the location where the data (or chart) is to be printed. 3. In the Home tab, click the Paste button arrow, then click Paste Special. 4. Make sure the Paste button is selected, then click Microsoft Excel Worksheet Object or Chart Object, then click OK.
List three advantages to linking data or a chart from an Excel file into a Word document.
1. When you double-click the linked data or chart, you are able to make edits directly in the source file. 2. Any change you make to the worksheet will appear in both the source and destination files. 3. Since the data remains stored in the source file, the destination file is smaller in size than copied or embedded data.
Linked File
A shortcut to a another file.
Embedded File
Data or chart that is pasted in a destination file as an object; it becomes part of that file and can be edited in source file mode.
After you edit linked data in the source file, what do you need to do to update the data in the destination file?
Right-click the data or chart and select Update Link.
What happens when you double-click in linked data or a linked chart in a destination file?
The Excel source file is opened so that the data or chart may be edited.
What happens when linked data or a linked chart is edited in the source file?
The data or chart is updated in the destination file.
Source File
This file provides the data in a copy and paste operation. The source files used in class have been Excel files.
Destination File
This file receives the data in a copy and paste operation. The destination files used in class have been Word files.
What happens when you double-click in data or a chart that has been embedded in a destination file?
You can edit the data in Excel mode.