ValueChange object (Excel)

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

Remarks

The PivotTableChangeList collection contains ValueChange objects that represent changes that 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.

Methods

• Delete

Properties

• AllocationMethod
• AllocationValue
• AllocationWeightExpression
• Application
• Creator
• Order
• Parent
• PivotCell
• Tuple
• Value
• VisibleInPivotTable

See also

• Excel Object Model Reference

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.