Partager via


DocEvents_Event.PivotTableChangeSync Event

Occurs after changes to a PivotTable.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Event PivotTableChangeSync As DocEvents_PivotTableChangeSyncEventHandler
'Usage
Dim instance As DocEvents_Event
Dim handler As DocEvents_PivotTableChangeSyncEventHandler

AddHandler instance.PivotTableChangeSync, handler
event DocEvents_PivotTableChangeSyncEventHandler PivotTableChangeSync

Remarks

The PivotTableChangeSync event 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.

See Also

Reference

DocEvents_Event Interface

DocEvents_Event Members

Microsoft.Office.Interop.Excel Namespace