Slicer Connections Lost when Copying to New Workbook

Hi guys,

the main objective of the code is to create different workbooks that are going to be send to different people(with only their data).

I am using the filter to delete the data that I dont need and then create a new workbook, save it and close it. This has been working fine.

The issue is that I have two slicers in the 'DistMenu' sheet. When I open again the newest workbook, they slicers are disconnected to the pivot tables. This can be fix manually by selecting the slicers --> PivotTables Connections etc

I use the macro recording to get a code and work from there, but is giving me error '1004' "Unable to get the PivotTables property of the Worksheet class"

Any advice? Thanks

Please Login or Register  to view this content.

Bump to first page