PivotCell.DiscardChange method (Excel)

  • Article

Discards changes to the specified cell in a PivotTable report.

Syntax

expression.DiscardChange

expression A variable that represents a PivotCell object.

Return value

Nothing

Remarks

For a cell in a PivotTable based on an OLAP data source, the DiscardChange method removes the value or formula entered in the specified cell, and then runs a PivotTable update to retrieve the latest value from the data source. The data source value will be set to NULL by this method for the specified cell.

The method also removes all changes made to this cell from the Excel change list so that it will no longer be included in the UPDATE CUBE statement for the data source.

This method also recreates the session state for all other changes made in the transaction. This includes executing a ROLLBACK TRANSACTION statement, and then executing an UPDATE CUBE statement with all changes except for the specified cell.

For a cell in a PivotTable based on a non-OLAP data source, this method clears the edited cell.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.