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.