Dear all,
I want to select the slicer automatically with value = 0
when the pivot table refresh, Someone who knows how to make this work?
Thanks for your help / alternative solution ideas.
Dear all,
I want to select the slicer automatically with value = 0
when the pivot table refresh, Someone who knows how to make this work?
Thanks for your help / alternative solution ideas.
Last edited by kirana2014; 12-02-2020 at 04:41 PM.
Please put this code in Sheet Pivot
Dim t Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable) If t <> PivotTables("PivotTable2").RefreshDate Then t = PivotTables("PivotTable2").RefreshDate Application.EnableEvents = False Dim it As SlicerItem For Each it In ActiveWorkbook.SlicerCaches("Slicer_Amount").SlicerItems it.Selected = it.Caption = "0" Next End If Application.EnableEvents = True End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) t = PivotTables("PivotTable2").RefreshDate End Sub
Dear Bo_Ry
Is working
Thank you
It's possible if on pivot table the value 0 not found clear the filter
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks