Macros to undo pivot table connection with slicers

[nicholasseetoh]

Hi people,

I have about 33 slicers, each with around 10 connections to different pivot tables. I'm pretty new to this VBA thing and I'm tasked to write a macros so that I can undo all these connections at the same time.

To illustrate this a little clearer; if you were to right click any slicer that you have and click on "PivotTable Connections" you would find a number of ticked boxes indicating that that particular slicer is connected to the "ticked" pivot table. I need a VBA code to "untick" all these boxes for all these different slicers at the same time.

I would really appreciate it if someone were to be able to help me along with this. Thanks guys.