Chapter 29: Sharing Data with Other Office Applications
621
FIGURE 29.4The Word paste link options for an Excel range.
When an Excel chart is on the Clipboard, you can also choose the Paste Link option from Word’s
Paste Special dialog box.Note
When you paste an Excel chart to Word using the Microsoft Office Graphic Object option, only the chart’s
data is linked. All other modifications (such as formatting or changing the chart type) aren’t reflected in the
copy pasted in the Word document. When you activate the chart in Word, you can use the Chart Tools contex-
tual menu to make changes to the chart. n
To edit (or break) a link, activate Word and choose File ➪ Info ➪ Edit Links To Files, which dis-
plays the Links dialog box shown in Figure 29.5. Select the file from the Source File list and then
click the Break Link button. After breaking a link, the data remains in the destination document,
but it’s no longer linked to the source document.If the link has been broken (for example, the source file was moved or renamed), use the Change
Source button to specify the source file and re-establish the link.If the link isn’t showing updated information from the source file, you can force an update by
using the Update Now button.