How Do I Quickly Re-filter and Export My Pivot Table Views to PowerPoint Slides?

Can you also make PowerPoints of your analyses for us, so that we can directly use them for our meetings?

As much as I like getting new responsibilities, it would be a stretch to say I was jumping with joy at the prospect of spending a good hour or two on the mind-numbing activity of making screenshots of my Excels and pasting them in PowerPoint.

So, I went about seeking a way of doing it quickly and efficiently. Naturally, automation was the first approach that came to mind.

If you’re facing a similar hurdle, don’t panic – there’s a neat way around it!

You can easily use Excel’s VBA environment to copy your Excel content, call the PowerPoint application and paste it there.

My task at hand involved re-filtering the pivot table placed on a particular sheet about 10 times and copying its content after each re-fitlering on a set slide in a pre-defined PowerPoint presentation.

The code below does exactly this.

Naturally, because it was developed for such a specific case, most of it will have to be re-written to fit the requirements of any other scenario. What is directly transposable, however, is the bit that calls the PowerPoint environment in the beginning.

Most importantly, you need to make sure that the Microsoft PowerPoint Object Library is invocable from Excel by enabling the reference in Excel VBE Editor

Happy VBA coding!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.