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