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
Bookmarks