Application.Calculation (Excel)
Returns or sets an XlCalculation value that represents the calculation mode. Possible return values are 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