PivotTable.CommitChanges Method
Performs a commit operation on the data source of a PivotTable report based on an OLAP data source.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub CommitChanges
'Usage
Dim instance As PivotTable
instance.CommitChanges()
void CommitChanges()
Remarks
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.