WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler delegate

Office 2013 and later

A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The 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)

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

Parameters

Sh
Type: System.Object

The worksheet that contains the PivotTable.

TargetPivotTable
Type: Microsoft.Office.Interop.Excel.PivotTable

The PivotTable that contains the changes to discard.

ValueChangeStart
Type: System.Int32

The index to the first change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

ValueChangeEnd
Type: System.Int32

The index to the last change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

Show: