Skip to content

Latest commit

 

History

History
32 lines (21 loc) · 2.62 KB

cd467d92-dee0-d049-0457-ec85ef74adf8.md

File metadata and controls

32 lines (21 loc) · 2.62 KB

ValueChange Members (Excel)

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

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

Methods

Name Description
Delete Deletes the specified ValueChange object from the PivotTableChangeList collection.

Properties

Name Description
AllocationMethod Returns what method to use to allocate this value when performing what-if analysis. Read-only
AllocationValue Returns what value to allocate when performing what-if analysis. Read-only
AllocationWeightExpression Returns the MDX weight expression to use for this value when performing what-if analysis. Read-only
Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long .
Order Returns a value that indicates the order in which this change was performed relative to other changes in the PivotTableChangeList collection. Read-only
Parent Returns the parent object for the specified object. Read-only.
PivotCell Returns a PivotCell object that represents the cell (tuple) that was changed. Read-only
Tuple Returns the MDX tuple of the value was changed in the OLAP data source. Read-only
Value Returns the value that the user entered in the cell or that the formula in the cell was evaluated to when UPDATE CUBE statement was last run against the OLAP data source. Read-only
VisibleInPivotTable Returns whether the cell (tuple) is currently visible in the PivotTable report. Read-only