CalculationMode Property

Gets or sets the value which indicates how a formula will be recalculated when a referenced value changes.

Syntax

Visual Basic

'Declaration
 
Public Property CalculationMode As CalculationMode

C#

public CalculationMode CalculationMode {get; set;}

Property Value

The value which indicates how a formula will be recalculated when a referenced value changes.

Exceptions

Exception	Description
System.ComponentModel.InvalidEnumArgumentException	The assigned value is not defined in the CalculationMode enumeration.

Remarks

If this is set to a value of Manual, the RecalculateBeforeSave property will determine if formulas are recalculated just before saving the file. Otherwise, that property is ignored.

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