Help with Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable)

[rv02]

Dear All

I have a quick question and will appreciate your help

I am using

Please Login or Register  to view this content.

and this works when I have it in the sheet where the pivot table is.

However I have a table which looks at values in my pivot sheet where the pivot table is and I have copied the slicer on to this sheet. The sheet is called Pivot_copy

When I use pivot table change sync in Pivot_copy sheet it doesn't work as the pivot table is in sheet called Pivot.

Is there anyway I can declare my target to be sheet("Pivot") pivot table name or does this need to reside on the sheet where pivot table is.

Hope this is clear and thanks in advance

[Gatti]

Hi! Could you please post a dummie workbook with your example?

Thanks!

[rv02]

Hi
I think I just gigured out what to do, I put the code in the sheet where the pivot table is and used a call function in Pivot Caopy