DocEvents_Event.PivotTableBeforeCommitChanges 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 PivotTableBeforeCommitChanges As DocEvents_PivotTableBeforeCommitChangesEventHandler
'Usage
Dim instance As DocEvents_Event
Dim handler As DocEvents_PivotTableBeforeCommitChangesEventHandler
AddHandler instance.PivotTableBeforeCommitChanges, handler
event DocEvents_PivotTableBeforeCommitChangesEventHandler PivotTableBeforeCommitChanges
Remarks
The PivotTableBeforeAllocateChanges event occurs immediately before Excel executes an COMMIT TRANSACTION against the PivotTable's OLAP data source, and immediately after the user has chosen to save changes for the whole PivotTable.