編輯

共用方式為


AppEvents_Event.SheetPivotTableBeforeCommitChanges Event

Definition

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

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

Event Type

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