DataSetChange Event
Occurs whenever the specified PivotTable view is data-bound and the data set changes — for example, when a filter operation takes place. This event also occurs when initial data is available from the data source.
Private Sub Form_DataSetChange()
Example
The following example demonstrates the syntax for a subroutine that traps the DataSetChange event.
Private Sub Form_DataSetChange()
MsgBox "The data set for the PivotChart view has changed."
End Sub