DocEvents_Event.PivotTableBeforeDiscardChanges Event
Occurs before changes to a PivotTable are discarded.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Event PivotTableBeforeDiscardChanges As DocEvents_PivotTableBeforeDiscardChangesEventHandler
'Usage
Dim instance As DocEvents_Event
Dim handler As DocEvents_PivotTableBeforeDiscardChangesEventHandler
AddHandler instance.PivotTableBeforeDiscardChanges, handler
event DocEvents_PivotTableBeforeDiscardChangesEventHandler PivotTableBeforeDiscardChanges
Remarks
Occurs immediately before Excel executes a ROLLBACK TRANSACTION statement against the OLAP data source, if a transaction is still active, and then discards all edited values in the PivotTable, after the user has chosen to discard changes.