Disconnect Slicer, Change Pivot Source, Reonnect Slicer

Hello All,

I have a dashboard worksheet which includes several pivot tables and slicer.

I prepared a macro with the help of a forum post by Izandol (#14) "How do i change SourceData for all pivots in workbook while disconnect/connect slicers" (I couldn't insert link)

Please Login or Register  to view this content.

However, I got an Invalid procedure call error on below line.

Please Login or Register  to view this content.

I hope someone can help me? Because I spent more than 4 hours for this problem
BW

Originally Posted by Pepe Le Mokko

Administrative Note:

Welcome to the forum

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

As you are new I will add it for you. Please read forum rules

Thank you for notice Pepe, but as I write on the first post, I couldn't insert any link. When I try I got "You are not allowed to post any kinds of links, images or videos until you post a few times.
Your Message" notice.

But I understand your concerns, Thank you again.

Insofar you only have one post that is correct.
OTOH, you can always add a link stripped of the http part or add a sentence to indicate you cross posted and where.
Anyway, if you have understood the importance of adding links, it's OK.

Oh, and please do not quote entire posts unnecessarily. Use the " Quick reply" instead.