Application.Calculation Property (Excel)
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.
Application.Calculation = xlCalculationManual
Application.CalculateBeforeSave = True