Compartir a través de

DocEvents_Event.PivotTableBeforeDiscardChanges Event

  • Artículo

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.

See Also

Reference

DocEvents_Event Interface

DocEvents_Event Members

Microsoft.Office.Interop.Excel Namespace