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 microsoft.office.interop.excel.dll)
Usage
WithEvents workbookEvents_Event1 As WorkbookEvents_Event
Function workbookEvents_Event1_SheetPivotTableUpdate(Sh As Object, _
Target As PivotTable) As Void
Handles workbookEvents_Event1.SheetPivotTableUpdate
End Function
Syntax
Event SheetPivotTableUpdate As WorkbookEvents_SheetPivotTableUpdateEventHandler
event WorkbookEvents_SheetPivotTableUpdateEventHandler SheetPivotTableUpdate;
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.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000
Target Platforms
See Also
Reference
WorkbookEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace