BeforeQuery Event
Occurs when the PivotTable list queries its data source.
Private Sub Object_BeforeQuery()
Object The name of the PivotTable object that you are trapping this event for.
Remarks
This event occurs quite frequently. Some examples of actions that trigger this event include adding fields to the PivotTable list, moving fields, sorting, or filtering data.