BeforeQuery Event

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.