Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet Dim pt As PivotTable Const strField As String = "ZONA" Application.EnableEvents = False Application.ScreenUpdating = False on error resume next If Target.Address = "$F$16" Then For Each ws In ThisWorkbook.Worksheets For Each pt In ws.PivotTables With pt.PageFields(strField) .ClearAllFilters .CurrentPage = Target.Value End With Next pt Next ws End If Application.EnableEvents = True Application.ScreenUpdating = True End Sub