PivotCell.DiscardChange Method
Discards changes to the specified cell in a PivotTable report.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub DiscardChange
'Usage
Dim instance As PivotCell
instance.DiscardChange()
void DiscardChange()
Remarks
For a cell in a PivotTable based on an OLAP data source, the DiscardChange() method removes the value or formula entered in the specified cell, and then runs a PivotTable update to retrieve the latest value from the data source. The data source value will be set to a null reference (Nothing in Visual Basic) by this method for the specified cell. The method also removes all changes made to this cell from Excel's change list so that it will no longer be included in the UPDATE CUBE statement for the data source. This method also recreates the session state for all other changes made in the transaction. This includes executing a ROLLBACK TRANSACTION statement, and then executing an UPDATE CUBE statement with all changes except for the specified cell. For a cell in a PivotTable based on a non-OLAP data source, this method simply clears the edited cell.