Application.Calculation (Excel)

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

xlCalculationAutomatic - Excel controls recalculation, xlCalculationManual - Calculation is done when the user requests it, xlCalculationSemiautomatic - Excel controls recalculation but ignores changes in tables.

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

Application.Calculation = xlCalculationAutomatic
Application.Calculation procedure builder