Редагувати

Поділитися через

XlCellChangedState enumeration (Excel)

  • Стаття

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

Name Value Description
xlCellChangeApplied 3 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 2 The value in the cell has been edited or recalculated.
xlCellNotChanged 1 The value in the cell has not been edited or recalculated.

Remarks

Applying and saving changes applies only to PivotTable reports with OLAP data sources. For more information about the meaning of the xlCellChangedState enumeration constant values, see the CellChanged property of the PivotCell object.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.