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.

True if Excel will use iteration to resolve circular references.

enabled?: boolean;

boolean

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

maxChange?: number;

number

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

maxIteration?: number;

number