I had this code working for my pivot table/chart to update from a drop down list and its stopped working :(
Does anyone have any ideas why it has stopped working?
Private Sub Worksheet_Change(ByVal Target As Range)
'Update 20190604
Dim xPTable As PivotTable
Dim xPFile As PivotField...