| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.DiscardChanges method (Excel) |
vbaxl10.chm235193 |
|
|
9ee2905f-7dd1-81d2-7075-7fdc78ad6f1c |
05/08/2019 |
medium |
Discards all changes in the edited cells of a PivotTable report based on an OLAP data source.
expression.DiscardChanges
expression A variable that represents a PivotTable object.
Nothing
For a PivotTable report based on an OLAP data source, the method removes all values and formulas entered in value cells, and then runs a PivotTable update operation to retrieve the latest values from the data source. It sets the data source value to NULL for all value cells that are edited, and also executes a ROLLBACK TRANSACTION statement against the OLAP server.
If you try to execute this method for a PivotTable report based on a non-OLAP data source, this method generates a run-time error.
[!includeSupport and feedback]