Query Event

                  Applies To

Occurs whenever a PivotTable list query becomes necessary. The query may not occur immediately; it may be delayed until the new data is displayed.

Syntax

Private Sub PivotTable_Query(Reason As PivotQueryReasonEnum)

Reason   Required PivotQueryReasonEnum. Specifies the reason for the query.