Issue with Removing Pivot Tables from Slicers via VBA

I created a Dashboard that includes a few slicers connected to a number of pivot tables. When I update the source data, I run code that will remove the slicers so that I can refresh the pivot tables. Then I try to reconnect the pivot tables to the slicers. The issue I have is that the slicer connections are totally removed and not just unchecked, so the section of code that reconnects the slicers back to the pivot tables causes an error because there are no pivot tables in the list to connect to. Is there something I'm doing wrong in the code that is totally removing the pivot tables and not just unchecking them? Thanks for your help.

Please Login or Register  to view this content.

If it makes more sense to set a dynamic range for the data source, I'd love to try that. How do I set a dynamic range for the PivotTable data source? Thanks.

Setting a dynamic range for the PivotTable data source worked great! Don't have to run all that code! Thanks.

You are welcome. Sorry couldn't check forum earlier. Glad you got it solved.