DocEvents_Event::PivotTableBeforeCommitChanges event

Office 2013 and later

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)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

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.

Show: