This documentation is archived and is not being maintained.

ValueChange Object (Excel)

Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.

Version Added: Excel 2010

The PivotTableChangeList collection contains ValueChange objects that represent changes a user has made to value cells in a PivotTable report.

The properties of the ValueChange object specify details about the change that was made, such as the value of the change, the tuple associated with the cell that was changed, the order in which the change was made relative to other changes, and whether the cell is visible in the PivotTable. The ValueChange object also provides the PivotCell property that returns a PivotCell object that represents the cell that was changed, and provides additional information about the changed cell.

Show: