Worksheet PivotTableChangeSync Event

Syntax

Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable)

Enter Code

End Sub

This event occurs after changes to a PivotTable.

Required Parameters

Target

The PivotTable that was changed.

Worksheet PivotTableBeforeDiscardChanges Event

Syntax

Private Sub Worksheet_PivotTableBeforeDiscardChanges(ByVal TargetPivotTable As PivotTable, ByVal ValueChangeStart As Long, ByVal ValueChangeEnd As Long)

Enter Code

End Sub

This event occurs before changes to a PivotTable are discarded.

Required Parameters

TargetPivotTable

The PivotTable that contains the changes to discard.

ValueChangeStart

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

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.

Worksheet PivotTableBeforeCommitChanges Event

Syntax

Private Sub Worksheet_PivotTableBeforeCommitChanges(ByVal TargetPivotTable As PivotTable, ByVal ValueChangeStart As Long, ByVal ValueChangeEnd As Long, Cancel As Boolean)

Enter Code

End Sub

This event occurs before changes are committed against the OLAP data source for a PivotTable.

Required Parameters

TargetPivotTable

The PivotTable that contains the changes to commit.

ValueChangeStart

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

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.

Cancel

False when the event occurs. If the event procedure sets this argument to True, the changes are not committed against the OLAP data source of the PivotTable.

Worksheet PivotTableBeforeAllocateChanges Event

Syntax

Private Sub Worksheet_PivotTableBeforeAllocateChanges(ByVal TargetPivotTable As PivotTable, ByVal ValueChangeStart As Long, ByVal ValueChangeEnd As Long, Cancel As Boolean)

Enter Code

End Sub

This event occurs before changes are applied to a PivotTable.

Required Parameters

TargetPivotTable

The PivotTable that contains the changes to apply.

ValueChangeStart

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

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

False when the event occurs. If the event procedure sets this argument to True, the changes are not applied to the PivotTable and all edits are lost.

Worksheet PivotTableAfterValueChange Event

Syntax

Private Sub Worksheet_PivotTableAfterValueChange(ByVal TargetPivotTable As PivotTable, ByVal TargetRange As Range)

Enter Code

End Sub

This event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

Required Parameters

TargetPivotTable

The PivotTable that contains the edited or recalculated cells.

TargetRange

The range that contains all the edited or recalcuated cells.