Tables in PowerPoint Presentation

[gymwrecker]

I have copied a series of tables from my Excel workbook into a Powerpoint presentation. This presentation is to be used on a monthly basis. Is it possible to update the data in the workbook, and it will automatically update on the Powerpoint presentation? Please advice.

Thanks in advance..!

 

[Damon Ostrander]

Hi gymwrecker,

It will update automatically if you paste the Excel tables into Powerpoint using Paste Special > Microsoft Excel Worksheet Object. But before clicking OK on the Paste Special dialog select the Paste Link optionbutton.

Keep Excelling.

Damon

 

[gymwrecker]

Great! One more question, do I have to save the PPT presentation and the Excel workbook all in the same folder for this to work?

 

[Damon Ostrander]

No, don't have to put them in the same folder. But if you put the linked-to file one place, then move it later to another, the link will be broken. So it is important to put it in a permanent place.

Damon