AppEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate

A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[ComVisibleAttribute(false)]
public delegate void AppEvents_SheetPivotTableBeforeAllocateChangesEventHandler(
	Object Sh,
	PivotTable TargetPivotTable,
	int ValueChangeStart,
	int ValueChangeEnd,
	out bool Cancel
)

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 apply.

ValueChangeStart
Type: System.Int32

The index to the first change in the associated PivotTableChangeList collection. 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 collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

Cancel
Type: System.Boolean

false when the event occurs. If the event procedure sets this parameter to true, the changes are not applied to the PivotTable and all edits are lost.

Show: