Purpose
Occurs before changes are committed against the OLAP data source for a PivotTable.
Syntax
SheetPivotTableBeforeCommitChanges(Sh, TargetPivotTable, ValueChangeStart, ValueChangeEnd, Cancel)
Required Parameters
Sh
The worksheet that contains the PivotTable.
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.
