Occurs before changes to a PivotTable are discarded.
Syntax
expression.SheetPivotTableBeforeDiscardChanges (Sh, TargetPivotTable, ValueChangeStart, ValueChangeEnd)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Sh | Required | Object | |
| TargetPivotTable | Required | PivotTable | The PivotTable that contains the changes to discard. |
| ValueChangeStart | Required | Long | 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 | Required | Long | 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. |
Return value
Nothing
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.