IterativeCalculationsEnabled Property

'Declaration
 
Public Property IterativeCalculationsEnabled As System.Boolean

public System.bool IterativeCalculationsEnabled {get; set;}

Property Value

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.

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

Reference

Workbook Class
Workbook Members
Circularity Property
MaxChangeInIteration Property
MaxRecursionIterations Property