Sub Selection()
Dim MaSelect As String
On Error Resume Next
MaSelect = Range("OfficineSelector").Value
ActiveSheet.PivotTables("PivotTable1").PivotFields("[Offines].[officine].[officine]").CurrentPageName = "[Offines].[officine].&[" & MaSelect & "]"
End Sub