ValueChange Interface
Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<GuidAttribute("000244C0-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface ValueChange
'Usage
Dim instance As ValueChange
[GuidAttribute("000244C0-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface ValueChange
Remarks
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.