Partager via

AppEvents_Event.SheetPivotTableBeforeCommitChanges Event

  • Article

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.

See Also

Reference

AppEvents_Event Interface

AppEvents_Event Members

Microsoft.Office.Interop.Excel Namespace