IterativeCalculationsEnabled Property

Gets or sets the value which indicates whether iterations are allowed while calculating formulas containing circular references.

Syntax

Visual Basic

'Declaration
 
Public Property IterativeCalculationsEnabled As Boolean

C#

public bool IterativeCalculationsEnabled {get; set;}

Property Value

The value which indicates whether iterations are allowed while calculating recursive formulas.

Remarks

When iterative calculations are enabled, a formula is allowed to use circular references, or directly or indirectly reference the cell to which it belongs. Microsoft Excel stops iteratively calculating formulas after iterating MaxRecursionIterations times or when all formula values change by less than MaxChangeInIteration between two iterations.

When iterative calculations are disabled, circular references are not allowed, and a formula which references the cell to which it belongs, directly or indirectly, will cause Microsoft Excel to show an error message and the cell will contain a Circularity error.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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