CalculationMode
Represents the the ways formulas are recalculated when their referenced values change.
Enumeration Members
Section titled "Enumeration Members"Automatic
Section titled "Automatic"Formulas and data tables are automatically recalculated when the values in referenced cells change.
Automatic = 1AutomaticExceptForDataTables
Section titled "AutomaticExceptForDataTables"Only formulas are automatically recalculated when the values in referenced cells change. Data tables must be recalculated manually.
AutomaticExceptForDataTables = 2Manual
Section titled "Manual"Formulas must be recalculated manually, by pressing a button in the Microsoft Excel interface.
Manual = 0