This documentation is archived and is not being maintained.

WorkbookEvents_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 workbookEvents_Event1 As WorkbookEvents_Event
Function workbookEvents_Event1_SheetPivotTableUpdate(Sh As Object, _
	Target As PivotTable) As Void
	Handles workbookEvents_Event1.SheetPivotTableUpdate
End Function

event WorkbookEvents_SheetPivotTableUpdateEventHandler SheetPivotTableUpdate;
 void add_SheetPivotTableUpdate(WorkbookEvents_SheetPivotTableUpdateEventHandler handler);
 void remove_SheetPivotTableUpdate(WorkbookEvents_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