Application.Calculation Property

  • Article
Excel Developer Reference

Returns or sets a XlCalculation value that represents the calculation mode.

Syntax

expression.Calculation

expression   A variable that represents an Application object.

Remarks

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

Example

This example causes Microsoft Excel to calculate workbooks before they are saved to disk.

Visual Basic for Applications 
  Application.Calculation = xlCalculationManual
Application.CalculateBeforeSave = True

See Also