Export (0) Print
Expand All

PivotTable.DiscardChanges Method (Excel)

Discards all changes in the edited cells of a PivotTable report based on an OLAP data source.

Version Added: Excel 2010

expression .DiscardChanges

expression A variable that represents a PivotTable object.

Return Value

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.

Show:
© 2014 Microsoft