If multiple pivot tables are based on the same data source, you can create a slicer, and connect it to one or more of those pivot tables. Selected = False End If Next si Long exit Handler: Application. Enable Events = True Exit Sub err Handler: Msg Box "Could not update pivot table" Resume exit Handler End Sub The final step is to move the slicers -- the short list slicer will go onto the main sheet, beside the original pivot table.However, if there are pivot tables from different data sources, you can't connect the to the same slicer. The long slicer will go onto the short list sheet, where it will be updated by the code.Close the user form [Command Button1] user form name is in brackets Dim trial As Long Private Sub Command Button1_Click() ' Unload User Form Unload Me End Sub Reset the user form [Command Button2] user form name is in brackets Private Sub Command Button2_Click() 'reset userform Unload Me User Form1.
similar to the first and I can't spot the difference betwen the the file where the macro executes and the second file where the macro is unavailable.
I tried a different "second" file and still get the same error Just a guess It is possible that because you have made the new workbook the active workbook that the macro is not available when this new workbook is closed.
Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click.
In Excel 2013, you can also use slicers on formatted Excel tables.
Also, if its the same macro, why not just run the macro from This Workbook where you're doing the initial processing? Name is the name of the workbook, re: wb Target wb Target. I am running this on a windows 2008 standard server, could this be an issue?