CalculationMode Enumeration

Represents the the ways formulas are recalculated when their referenced values change.

Syntax

Visual Basic

'Declaration
 
Public Enum CalculationMode 
   Inherits System.Enum

C#

public enum CalculationMode : System.Enum 

Members

Member	Description
Automatic	Formulas and data tables are automatically recalculated when the values in referenced cells change.
AutomaticExceptForDataTables	Only formulas are automatically recalculated when the values in referenced cells change. Data tables must be recalculated manually.
Manual	Formulas must be recalculated manually, by pressing a button in the Microsoft Excel interface.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2