PivotCell.DiscardChange method (Excel)
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for