OLE stands for Object Linking and Embedding. It enables you to copy existing Excel data such as a table or a chart into a presentation. You then have the option to either embed the data, or create a link to it.
Embedding the Excel data will allow you to make changes to the data using Excel functionality from with PowerPoint. However it remains independent from the spreadsheet. Creating a link to the Excel data will mean that whenever the spreadsheet data is changed, the PowerPoint presentation is automatically updated.
Open the spreadsheet containing the data
Select the range of cells or chart you want to copy
Click Edit > Copy or press Ctrl + C to copy the data
Switch to the PowerPoint presentation and select the slide you want to import the data to
Click Edit > Paste Special
The Paste Special dialogue box appears. Select Microsoft Office Excel Worksheet Object or Microsoft Office Excel Chart Object from the list of formats
Click the Paste option to embed the object, or click the Paste Link option to create a link to the spreadsheet
Optionally check the Display as icon box to display the Excel icon instead of the data. This is useful if the data you are importing is large and does not fit on your slide. The data can be viewed by double clicking the icon
Click Ok
The data appears on the slide as an object. It can be moved and resized to fit in with any other content you may have on the slide.
Deixe o seu comentario
Post a Comment