| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.CommitChanges method (Excel) |
vbaxl10.chm235192 |
|
|
f64031c6-8309-7c8a-5786-949d2ec10dea |
05/08/2019 |
medium |
Performs a commit operation on the data source of a PivotTable report based on an OLAP data source.
expression.CommitChanges
expression A variable that represents a PivotTable object.
Nothing
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.
[!includeSupport and feedback]