PowerPoint Presentations through VBA using Pivots and charts available in Excel.

[anmolsmatie]

Hi,

I am preparing a presentation in PowerPoint. It is a monthly deck of almost 25 slides which takes almost 5-6 hours. Is it possible to prepare it through VBA. It includes data coming from different Pivots in excel.

Can please anyone help me with any reference on how to do it.

 

[XLfriend777]

Hi anmolsmatie - I found the following YouTube video to be very helpful in explaining linking an excel spreadsheet to a PowerPoint presentation:

How to Link Excel worksheet to PowerPoint 2010 - YouTube

Hope this helps.

Happy Excelling,

goesr