Excel.Application.WorkbookPivotTableOpenConnection.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.WorkbookPivotTableOpenConnection event (Excel)	vbaxl10.chm504096	vbaxl10.chm504096	Excel.Application.WorkbookPivotTableOpenConnection	5f07e995-96fd-86ac-2d1c-1366528fd8c6	04/05/2019	medium

Application.WorkbookPivotTableOpenConnection event (Excel)

Occurs after a PivotTable report connection has been opened.

Syntax

expression.WorkbookPivotTableOpenConnection (Wb, Target)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
Wb	Required	Workbook	The selected workbook.
Target	Required	PivotTable	The selected PivotTable report.

Return value

Nothing

Example

This example displays a message stating that the PivotTable report's connection to its source has been opened. This example assumes that you have declared an object of type Workbook with events in a class module.

Private Sub ConnectionApp_WorkbookPivotTableOpenConnection(ByVal wbOne As Workbook, Target As PivotTable) 
 
 MsgBox "The PivotTable connection has been opened." 
 
End Sub

[!includeSupport and feedback]