Workbook PivotTableOpenConnection Event


Syntax
Private Sub Workbook_PivotTableOpenConnection(ByVal Target As PivotTable)
Enter Code
End Sub

This event will run every time a pivot table connection is closed within the specific workbook.

Required Parameters
Target
The target parameter returns the pivot table with connection being opened.  This parameter returns a Pivot Table object to allow users to manipulate the events, methods and properties.