Workbook.SheetPivotTableBeforeDiscardChanges Event (Excel)
Occurs before changes to a PivotTable are discarded.
Version Information
Version Added: Excel 2010
Syntax
expression .SheetPivotTableBeforeDiscardChanges(Sh, TargetPivotTable, ValueChangeStart, ValueChangeEnd)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Sh |
Required |
Object |
|
TargetPivotTable |
Required |
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.