Excel.Interfaces.IterativeCalculationUpdateData interface

An interface for updating data on the IterativeCalculation object, for use in iterativeCalculation.set({ ... }).

Properties

enabled

True if Excel will use iteration to resolve circular references.

[ API set: ExcelApi 1.9 ]

maxChange

Returns or sets the maximum amount of change between each iteration as Excel resolves circular references.

[ API set: ExcelApi 1.9 ]

maxIteration

Returns or sets the maximum number of iterations that Excel can use to resolve a circular reference.

[ API set: ExcelApi 1.9 ]

Property Details

enabled

True if Excel will use iteration to resolve circular references.

[ API set: ExcelApi 1.9 ]

enabled?: boolean;

Property Value

boolean

maxChange

Returns or sets the maximum amount of change between each iteration as Excel resolves circular references.

[ API set: ExcelApi 1.9 ]

maxChange?: number;

Property Value

number

maxIteration

Returns or sets the maximum number of iterations that Excel can use to resolve a circular reference.

[ API set: ExcelApi 1.9 ]

maxIteration?: number;

Property Value

number