Calculation

xlCalculation	Specifies the calculation mode.
xlCalculationInterruptKey	Specifies which key interrupts recalculation.
xlCalculationState	Specifies the calculation state of the application.
xlThreadMode	Specifies the control over the multi-threaded calculation mode.

xlCalculation Specifies the calculation mode.
xlCalculationInterruptKey Specifies which key interrupts recalculation.
xlCalculationState Specifies the calculation state of the application.
xlThreadMode Specifies the control over the multi-threaded calculation mode.

xlCalculation

Specifies the calculation mode.

xlCalculationAutomatic	Excel controls recalculation (-4105)
xlCalculationManual	Calculation is done when the user requests it (-4135)
xlCalculationSemiautomatic	Excel controls recalculation but ignores changes in tables (2)

xlCalculationAutomatic

Excel controls recalculation (-4105)

xlCalculationManual

Calculation is done when the user requests it (-4135)

xlCalculationSemiautomatic

Excel controls recalculation but ignores changes in tables (2)

REMARKS

* This enumeration replaces the following three constants.
* xlConstants.xlManual
* xlConstants.xlAutomatic
* xlConstants.xlSemiautomatic

xlCalculationInterruptKey

Specifies which key interrupts recalculation.

xlAnyKey	Pressing any key interrupts recalculation (2)
xlEscKey	Pressing the ESC key interrupts recalculation (1)
xlNoKey	No key press can interrupt recalculation (0)

xlAnyKey

Pressing any key interrupts recalculation (2)

xlEscKey

Pressing the ESC key interrupts recalculation (1)

xlNoKey

No key press can interrupt recalculation (0)

REMARKS

* Added in 2002.

xlCalculationState

Specifies the calculation state of the application.

xlCalculating	Calculations are in process (1)
xlDone	Calculations have finished (0)
xlPending	Calculation has been triggered but not yet been performed (2)

xlCalculating

Calculations are in process (1)

xlDone

Calculations have finished (0)

xlPending

Calculation has been triggered but not yet been performed (2)

REMARKS

* Added in 2002.

xlThreadMode

Specifies the control over the multi-threaded calculation mode.

xlThreadModeAutomatic	This tells Excel to use all the processors on this computer (0)
xlThreadModeManual	This lets you tell Excel how many processors you want to use (1)

xlThreadModeAutomatic

This tells Excel to use all the processors on this computer (0)

xlThreadModeManual

This lets you tell Excel how many processors you want to use (1)

REMARKS

* Added in 2007.
* xlThreadModeManual lets you use the Application.MultiThreadedCalculation.ThreadCount property to set how many you want to use.
* More details can be found on Formulas > Calculation - Multi Threading