OnDisconnect Event

Occurs when the PivotTable list is explicitly disconnected from a data source, or the connection is changed to a different data source.

Private Sub Object_OnDisconnect()

Object    The name of the PivotTable object that you are trapping this event for.

Applies to | PivotTable Object