QueryComplete Event

                  Applies To

Occurs after a PivotTable list query has completed.

Syntax

Private Sub PivotTable_QueryComplete()

Remarks

For information about using events with VBSCript, see Declaring and Using Event Procedures in VBScript.

You should not use the Requery method (or any other method that causes a query) while handling the QueryComplete event.