AppEvents_Event.SheetPivotTableBeforeDiscardChanges 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 SheetPivotTableBeforeDiscardChanges As AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler
'Usage
Dim instance As AppEvents_Event
Dim handler As AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler
AddHandler instance.SheetPivotTableBeforeDiscardChanges, handler
event AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler SheetPivotTableBeforeDiscardChanges
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.