ValueChange Properties (Excel)

Office 2013

Published: July 16, 2012

This object has the following 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

Community Additions

ADD
Show:
© 2014 Microsoft