PivotCell.CellChanged (Excel)

Returns whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. Possible return values are xlCellChangeApplied - The value in the cell has been edited or recalculated, and that change has been applied to the data source. (Applies only PivotTable reports with OLAP data sources), xlCellChanged - The value in the cell has been edited or recalculated, xlCellNotChanged - The value in the cell has not been edited or recalculated.

The value of the CellChanged property is xlCellNotChanged by default. For PivotTable reports with non-OLAP data sources, the value of this property can be only xlCellNotChanged or xlCellChanged. It is xlCellNotChanged for cells that have not been edited, and is xlCellChanged for cells that have been edited. Discarding changes sets its value to xlCellNotChanged. Applying and saving changes applies only to PivotTable reports with OLAP data sources. The following list of descriptions of the possible states of the CellChange property apply only to PivotTables with OLAP data sources:

Dim xccCellChanged As XlCellChangedState
xccCellChanged = ActiveCell.PivotCell.CellChanged