Update PowerPoint Slide from Excel Sheet with Macros

[HectorSucad]

Goodmorning,

I need to create a Macro in my Excel Sheet, which automatically updates a graph on a PowerPoint Slide.
Both Files already exist and I just need to tell two kinds of things: "copy this from excel and paste it here on the slide" and "copy this from excel, open this graph inputs and paste it here"

I put on VBA the Microsoft PowerPoint 2016 Object Library, but still I cannot access the Slide.

Can someone help? Am I missing something?

 

[taisafelix]

No need to use macros. A simple copy past will do the trick.

1. Copy the cell/Table/Chart in Excel
2. Go to your Power Point Presentation
3. Go to Past Options -> Paste Special

4. Select Past Link Microsoft Excel Worksheet:

From now on every time you change something in your Excel it will automatically change in your presentation. For me, the main drawback of this technic is that you can't do any formatting in the cell you paste. If you need to change something it has to be done in the Excel file.

 

[taisafelix]

No need to use macros. A simple copy past will do the trick.

1. Copy the cell/Table/Chart in Excel
2. Go to your Power Point Presentation
3. Go to Past Options -> Paste Special

View attachment 39084


4. Select Past Link Microsoft Excel Worksheet:
View attachment 39085

From now on every time you change something in your Excel it will automatically change in your presentation. For me, the main drawback of this technic is that you can't do any formatting in the cell you paste. If you need to change something it has to be done in the Excel file.

For more details:

Insert and update Excel data in PowerPoint - Microsoft Support

You can link data from an Excel spreadsheet to your presentation. If the data on the spreadsheet changes, you can update it in your presentation with just a few clicks.

support.microsoft.com