Disconnect slicers, dynamically update pivot table data source range et reconnect

Hey everyone, I'm a noob trying to learn. I built a dashboard with charts and slicers made from pivot tables. I would love to be able to update the data source range automatically (which requires disconnecting all slicers, updating and then reconnecting everything) using VBA.

I found this piece of code but I don't really know how to use it...

Can you help me please?

Thank you very much,

vincent

Please Login or Register  to view this content.

It looks like the only thing you need to change is this line:

Please Login or Register  to view this content.

to match the names of the slicers you need to disconnect.

Thanks

There seems to be other parameters I need to change like "eLink_Raw" in

Please Login or Register  to view this content.

Also I can't figure out what "Slicer_" mean in this line of code:

Please Login or Register  to view this content.

Thanks for your help!

By default the slicer cache is called Slicer_ followed by the name of the field you attached the slicer to. What did you alter the array to?

thanks, I added my slicers.. for some reason the "Slicer_" seems to cause errors in my code

What does:

Please Login or Register  to view this content.

show?