Edit

Share via


PivotCell.CellChanged Property

Definition

Gets whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.

public:
 property Microsoft::Office::Interop::Excel::XlCellChangedState CellChanged { Microsoft::Office::Interop::Excel::XlCellChangedState get(); };
public Microsoft.Office.Interop.Excel.XlCellChangedState CellChanged { get; }
Public ReadOnly Property CellChanged As XlCellChangedState

Property Value

A XlCellChangedState object.

Remarks

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 either 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 descriptions of the possible states of the CellChanged property apply only to PivotTables with OLAP data sources.

  • xlCellNotChanged - the cell has not been edited or recalculated (if the cell contains a formula) since the PivotTable was created, or since the last save or discard changes operation was performed.
  • xlCellChanged - the cell has been edited or recalculated since the PivotTable was created, or since the last apply changes or save changes operation was performed, but that change has not yet been applied (the UPDATE CUBE statement has not been run for it).
  • xlCellChangeApplied- the cell has been edited or recalculated since the PivotTable was created, or since the last apply changes, save changes, or discard changes operation was performed, and that change has been applied (the UPDATE CUBE statement has been run for it).

The following table describes how different actions by the user affect the setting of the CellChanged property in a PivotTable with an OLAP data source.

Types a value or formula into a cell or multiple cells.Set to xlCellChanged for those cells.Set to xlCellChanged for those cells.
Recalculates a cell or multiple cells with a formula, either manually (F9) or automatically by Excel.N/ASet to xlCellChanged for those cells.
Saves (commits) changes.Set to xlCellNotChanged for all edited cells without a formula.Set to xlCellChangeApplied for all edited cells with a formula.
Discards all changes.Set to xlCellNotChanged for all edited cells without a formula.Set to xlCellNotChanged for all edited cells with a formula.
Discards change in single cell.Set to xlCellNotChanged for that cell only.Set to xlCellNotChanged for that cell only.
Clears multiple cells in one operation.Set to xlCellNotChanged for all those cells.Set to xlCellNotChanged for all those cells.
Clears a cell.Set to xlCellNotChanged for that cell only.Set to xlCellNotChanged for that cell only.
Performs an undo operation that changes the value back to a previously edited value, before that value was applied.Set to xlCellChanged for all edited cells without a formula.Set to xlCellChanged for all edited cells with a formula.
Performs an undo operation that changes the value back to a previously edited value, after that value was applied.Set to xlCellChangeApplied for all edited cells without a formula.Set to xlCellChangeApplied for all edited cells with a formula.

Applies to