OnDisconnect Event

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

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