Hi,

One of my frequent tasks at work require generating multiple PowerPoint presentations from Excel pivot tables and pivot charts. Therefore I am very interested in automating the entire process as much as possible. Basically, these different presentations are populated from the same pivot tables/charts with different filter settings. Currently, I have a slicer connected to all pivot tables/charts which allows me update all Excel pivot tables/charts as well as PowerPoint slides accordingly (PowerPoint tables and charts are linked to the Excel file). This is working well. However, for each slicer setting, I have to manually (in PowerPoint) break links into data sources (Edit Links to Files option) to avoid changing the slides when the slicer settings change, and then manually save the presentation to a different file.

Given that the number of options in the slicer is relatively large (about 50) and the fact that I need to go over this procedure quite frequently, I have been wondering if it is do-able to automate this process any further. Ultimately, what I am interested in is a procedure that would iterate over all slicer options in Excel (updating the PowerPoint slides) and save individual presentations to different files. Given my fairly limited knowledge of VBA I am not really able to figure out if it's feasible at all and, if so, where to start.



I use in Office 2010. Unfortunately, I am not allowed to use/install any additional software to complete this task.

Thank you in advance for any suggestions!
Voytek