AppEvents_Event.SheetPivotTableBeforeCommitChanges Event
Occurs before changes are committed against the OLAP data source for a PivotTable.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Event SheetPivotTableBeforeCommitChanges As AppEvents_SheetPivotTableBeforeCommitChangesEventHandler
'Usage
Dim instance As AppEvents_Event
Dim handler As AppEvents_SheetPivotTableBeforeCommitChangesEventHandler
AddHandler instance.SheetPivotTableBeforeCommitChanges, handler
event AppEvents_SheetPivotTableBeforeCommitChangesEventHandler SheetPivotTableBeforeCommitChanges
Remarks
The SheetPivotTableBeforeCommitChanges event occurs immediately before Excel executes a COMMIT TRANSACTION against the PivotTable's OLAP data source, and immediately after the user has chosen to save changes for the whole PivotTable.