Calculation Property

Calculation Property

See Also         Example         Applies To

Application object: Returns or sets the calculation mode. Can be one of the following XlCalculation constants: xlCalculationAutomatic, xlCalculationManual, or xlCalculationSemiautomatic.

PivotField object: Returns or sets the type of calculation performed by the specified field. Can be one of the following XlPivotFieldCalculation constants: xlDifferenceFrom, xlIndex, xlNormal, xlPercentDifferenceFrom, xlPercentOf, xlPercentOfColumn, xlPercentOfRow, xlPercentOfTotal, or xlRunningTotal. This property is valid only for data fields. Read/write Long.

Remarks

For OLAP data sources, this property can only return or be set to xlNormal.