Excel.Application.WorkbookPivotTableCloseConnection.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.WorkbookPivotTableCloseConnection event (Excel)	vbaxl10.chm504095	vbaxl10.chm504095	Excel.Application.WorkbookPivotTableCloseConnection	4c1d4cb2-f589-3c3c-ab4c-dcb08467fcfb	04/05/2019	medium

Application.WorkbookPivotTableCloseConnection event (Excel)

Occurs after a PivotTable report connection has been closed.

Syntax

expression.WorkbookPivotTableCloseConnection (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 closed. This example assumes that you have declared an object of type Workbook with events in a class module.

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

[!includeSupport and feedback]