Page 523 - Excel 2013 All-in-One For Dummies

Excel 2013 Data Sharing Basics 505
The links that bind
Of course, as nice as embedding is, you will encounter occasions when link- ing the Excel data to the Word document is the preferred method (and, in fact, even easier to do). First, I select a chart that I created in the worksheet by single-clicking it, not double-clicking it, as I would do to edit the chart in the worksheet.
Then, after copying the chart (or selected data) to the Clipboard by click- ing the Copy command on the Excel Ribbon’s Home tab, I switched over to Word and my memo to all store managers. After positioning the insertion point at the beginning of the paragraph where the chart needs to be, I chose the Paste Special option from the Paste button’s drop-down menu on the Home tab of Word’s Ribbon. (You can also do this by pressing Alt+HVS.) Figure 4-7 shows the Paste Special dialog box that appears. In this dialog box, the crucial thing is to select the Paste Link option button and Microsoft Excel Chart Object in the list box before clicking OK. Figure 4-8 shows the Word memo after I clicked OK and pasted the Excel chart into place.
Figure 4-7:
Selecting the Paste Link option in Word’s Paste Special dialog box.
Editing linked data
Editing data linked to Excel (as a chart or cells) is not quite as delightful as editing embedded worksheet data. For one thing, you first have to go back to Excel and make your changes — although you can easily open Excel and its workbook just by double-clicking the linked chart. The nice thing, however is that any changes that you make to the original data or chart are immedi- ately reflected in the Word document the moment you open it.
Book IV Chapter 4
Sharing Workbooks and Worksheet Data