Partager via

DocEvents_Event.PivotTableBeforeCommitChanges 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 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.

See Also

Reference

DocEvents_Event Interface

DocEvents_Event Members

Microsoft.Office.Interop.Excel Namespace