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.

maxChange

Specifies the maximum amount of change between each iteration as Excel resolves circular references.

maxIteration

Specifies the maximum number of iterations that Excel can use to resolve a circular reference.

Property Details

enabled

True if Excel will use iteration to resolve circular references.

enabled?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

maxChange

Specifies the maximum amount of change between each iteration as Excel resolves circular references.

maxChange?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]

maxIteration

Specifies the maximum number of iterations that Excel can use to resolve a circular reference.

maxIteration?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]