Integrating Word and Excel ,

1. Integrating Word and Excel,

2. Objectives • Learn about object linking and embedding (OLE) • Embed an Excel chart in a Word document • Edit an embedded Excel chart in Word • Link an Excel worksheet to a Word document • Update a linked Excel worksheet • Test a link New Perspectives on Microsoft Office 2010

3. Embedding and Linking New Perspectives on Microsoft Office 2010

4. Object Linking and Embedding (OLE) • Office 2010 supports object linking and embedding (OLE, pronounced “oh-lay”), a way of transferring and sharing information between programs New Perspectives on Microsoft Office 2010

5. Object Linking and Embedding • With OLE, you can share data in one of two ways: • When you embed an object, a copy of the object along with a link to the source program become part of the destination file, and you can edit the object using the source program’s commands • When you link an object, a direct connection is created between the source and destination programs • The object exists in only one place New Perspectives on Microsoft Office 2010

6. Embedding an Excel Object in a Word Document • Start the source program (Excel), open the file containing the chart to be embedded, select the chart you want to embed in the destination file (a Word document), and then click the Copy button in the Clipboard group on the Home tab • Start the destination program (Word), open the file that will contain the embedded chart, and then position the insertion point where you want to place the chart • In the Clipboard group on the Home tab in Word, click the Paste button arrow, and then click the Keep Source Formatting & Embed Workbook button or the Use Destination Theme & Embed Workbook button New Perspectives on Microsoft Office 2010

7. Embedding an Excel Object in a Word Document or • Copy the chart from Excel, start Word, and then position the insertion point where you want to place the chart • In the Clipboard group on the Home tab in Word, click the Paste button. In the Word document window, click the Paste Options button that appears, and then click the Keep Source Formatting & Embed Workbook button or the Use Destination Theme & Embed Workbook button New Perspectives on Microsoft Office 2010

8. Embedding an Excel Object in a Word Document New Perspectives on Microsoft Office 2010

9. Modifying an Embedded Object • When you edit an embedded object within the destination program, the changes affect only the embedded object; the original object in the source program remains unchanged New Perspectives on Microsoft Office 2010

10. Linking Excel Worksheet Data to a Word Document • Start the source program (Excel), open the file containing the data to be linked, select the data you want to link to the destination program, and then click the Copy button in the Clipboard group on the Home tab • Start the destination program (Word), open the file that will contain the linked object, and then position the insertion point where you want to place the data • In the Clipboard group on the Home tab in Word, click the Paste button arrow, and then click the Link & Keep Source Formatting button or click the Link & Use Destination Styles button New Perspectives on Microsoft Office 2010

11. Linking Excel Worksheet Data to a Word Document or • Copy the data from Excel, start Word, and then position the insertion point where you want to place the data • In the Clipboard group on the Home tab in Word, click the Paste button. In the Word document window, click the Paste Options button that appears, and then click the Link & Keep Source Formatting button or click the Link & Use Destination Styles button New Perspectives on Microsoft Office 2010

12. Linking Excel Worksheet Data to a Word Document New Perspectives on Microsoft Office 2010

13. Updating Linked Objects • When you link an object, you can edit the information in the source file, and the changes will appear in the Word document New Perspectives on Microsoft Office 2010