How to automatically update Excel table data into PowerPoint

Categories: October 19, 2019 Quick Skills

The are many occasions where we need to display data from Excel into our PowerPoint slides.

Often, we may need to reuse these presentations and therefore need the data to stay up to date (reflecting any subsequent changes made to the Excel sheet).

Luckily this is not something that we need to worry about as PowerPoint and Excel play nicely together, allowing us to create dynamic data in our PowerPoint slides.

Follow the steps below to achieve real time Excel data in your presentations.

1 – Open Excel and copy your data

Open Excel and highlight the cells that contain the data you wish to link into your PowerPoint slides.

Right click and choose copy.

2 – Open PowerPoint

Open PowerPoint and find the slide you wish to display the linked Excel data.

3 – Paste the data

From the Home tab, find the Paste menu.

Choose Paste Special.

From the Paste Special dialog box, select Paste link, then choose Microsoft Excel Worksheet Object.

Click OK.

A live link has now been established between the two files.