| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Workbook.SheetPivotTableBeforeDiscardChanges event (Excel) |
vbaxl10.chm503105 |
|
|
e8f1ae21-c9ed-6f4d-a85c-d6768060a66f |
05/29/2019 |
medium |
Occurs before changes to a PivotTable are discarded.
expression.SheetPivotTableBeforeDiscardChanges (Sh, TargetPivotTable, ValueChangeStart, ValueChangeEnd)
expression A variable that represents a Workbook object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Sh | Required | Object | The worksheet that contains the PivotTable. |
| 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. |
Nothing
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.
[!includeSupport and feedback]