SheetPivotTableUpdate Event
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

AppEvents_Event.SheetPivotTableUpdate Event 

Occurs after the sheet of the PivotTable report has been updated.

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

WithEvents appEvents_Event1 As AppEvents_Event
Function appEvents_Event1_SheetPivotTableUpdate(Sh As Object, _
	Target As PivotTable) As Void
	Handles appEvents_Event1.SheetPivotTableUpdate
End Function

Event SheetPivotTableUpdate As AppEvents_SheetPivotTableUpdateEventHandler
 void add_SheetPivotTableUpdate(AppEvents_SheetPivotTableUpdateEventHandler handler);
 void remove_SheetPivotTableUpdate(AppEvents_SheetPivotTableUpdateEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

© 2015 Microsoft