Excel.Worksheet.PivotTableUpdate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.PivotTableUpdate event (Excel)	vbaxl10.chm502081	vbaxl10.chm502081	Excel.Worksheet.PivotTableUpdate	66186c97-6855-b360-a6c0-56da617d24a6	05/30/2019	medium

Worksheet.PivotTableUpdate event (Excel)

Occurs after a PivotTable report is updated on a worksheet.

Syntax

expression.PivotTableUpdate (Target)

expression A variable that represents a Worksheet object.

Parameters

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

Return value

Nothing

Example

This example displays a message stating that the PivotTable report has been updated. This example assumes that you have declared an object of type Worksheet with events in a class module.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) 
 
 MsgBox "The PivotTable connection has been updated." 
 
End Sub

[!includeSupport and feedback]