WorkbookEvents_Event.SheetPivotTableBeforeDiscardChanges WorkbookEvents_Event.SheetPivotTableBeforeDiscardChanges WorkbookEvents_Event.SheetPivotTableBeforeDiscardChanges Event

Definition

Occurs before changes to a PivotTable are discarded.

public:
 event Microsoft::Office::Interop::Excel::WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler ^ SheetPivotTableBeforeDiscardChanges;
event Microsoft.Office.Interop.Excel.WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler SheetPivotTableBeforeDiscardChanges;
Event SheetPivotTableBeforeDiscardChanges As WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler 

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.

Applies to