xlCellChangedState

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

xlCellChangeAppliedThe 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) (3)
xlCellChangedThe value in the cell has been edited or recalculated (2)
xlCellNotChangedThe value in the cell has not been edited or recalculated (1)

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) (3)
xlCellChanged
The value in the cell has been edited or recalculated (2)
xlCellNotChanged
The value in the cell has not been edited or recalculated (1)

REMARKS
* Added in 2010.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top