Excel.Worksheet.PivotTableChangeSync.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.PivotTableChangeSync event (Excel)	vbaxl10.chm502086	vbaxl10.chm502086	Excel.Worksheet.PivotTableChangeSync	b8cd1e24-4986-d3d4-c37a-b2933c6a9d99	05/30/2019	medium

Worksheet.PivotTableChangeSync event (Excel)

Occurs after changes to a PivotTable.

Syntax

expression.PivotTableChangeSync (Target)

expression A variable that represents a Worksheet object.

Parameters

Name	Required/Optional	Data type	Description
Target	Required	PivotTable	The PivotTable that was changed.

Return value

Nothing

Remarks

The PivotTableChangeEvent occurs during most changes to a PivotTable, so that you can write code to respond to user actions, such as clearing, grouping, or refreshing items in the PivotTable.

Example

The following code example displays a message box that shows the name of the PivotTable that the user changed.

Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable) 
 
With Target 
 MsgBox "You performed an operation in the following PivotTable: " & .Name 
End With 
 
End Sub

[!includeSupport and feedback]