Link Excel to PowerPoint (or Word)
A common requirement in the business world is to link parts of an Excel file into PowerPoint (or Word) in such a way that when the Excel file is updated, the PowerPoint (or Word) document is also updated. Below the method to link Excel to PowerPoint. you can follow the same steps in Word
First work on the Excel spreadsheet and get it correct. As shown below we have created a mini dashboard within the Excel file using pivot tables and pivot charts (but they can be plain cells and charts as well).
The following will appear. Very important, click on the Paste Link option and then choose the Microsoft Excel Worksheet Object and click OK.
You will see that the table now appears in your slide as shown below. Most important though, when you right click on the ‘picture’ you will notice that one of the options is now to UPDATE LINKS. This tells you that this image and the cells in the Excel file are now linked. If you change something in Excel, and refresh it in PowerPoint it will update on the slide.
- Click on the chart in Excel
- Copy it
- Go to the relevant PowerPoint slide
- Click on Paste Special
- Click on the Paste link option
- Choose Microsoft Excel Chart Object
- Click OK
As shown below you can export the entire dashboard into PowerPoint but make sure it stays linked to the Excel file (see below if you right click on the chart it also has the Update Link option).