Occurs whenever a PivotTable list field, field set, or total is added or deleted.
Syntax
Private Sub PivotTable_PivotTableChange(Reason As PivotTableReasonEnum)
Reason Specifies how the PivotTable list changed. Can be one of the PivotTableReasonEnum constants.