Export (0) Print
Expand All

Worksheet.PivotTableBeforeDiscardChanges Event (Excel)

Occurs before changes to a PivotTable are discarded.

Version Added: Excel 2010

expression .PivotTableBeforeDiscardChanges(TargetPivotTable, ValueChangeStart, ValueChangeEnd)

expression A variable that represents a Worksheet object.

Parameters

Name

Required/Optional

Data Type

Description

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft