WorkbookEvents_Event.SheetPivotTableBeforeCommitChanges WorkbookEvents_Event.SheetPivotTableBeforeCommitChanges WorkbookEvents_Event.SheetPivotTableBeforeCommitChanges Event

Definition

Occurs before changes are committed against the OLAP data source for a PivotTable.

public:
 event Microsoft::Office::Interop::Excel::WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler ^ SheetPivotTableBeforeCommitChanges;
event Microsoft.Office.Interop.Excel.WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler SheetPivotTableBeforeCommitChanges;
Event SheetPivotTableBeforeCommitChanges As WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler 

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.

Applies to