Edit

Excel.CalculationMode enum

Remarks

[Api set: ExcelApi 1.1]

Fields

automatic = "Automatic"

The default recalculation behavior where Excel calculates new formula results every time the relevant data is changed.

  • [Api set: ExcelApi 1.1]
automaticExceptTables = "AutomaticExceptTables"

Calculates new formula results every time the relevant data is changed, unless the formula is in a data table.

  • [Api set: ExcelApi 1.1]
manual = "Manual"

Calculations only occur when the user or add-in requests them.

  • [Api set: ExcelApi 1.1]