Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

PivotTable.CommitChanges Method (Excel)

Performs a commit operation on the data source of a PivotTable report based on an OLAP data source.

Version Added: Excel 2010

expression .CommitChanges

expression A variable that represents a PivotTable object.

Return Value


The CommitChanges method sends a COMMIT TRANSACTION statement to the OLAP server, and clears all cells that were edited by entering a value, but will not clear formulas in value cells. This method generates a run-time error if it is executed on a PivotTable report based on a non-OLAP data source.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.