Skip to main content

ValueChange object

Table of contents
  1. Remarks

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


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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>