MaxIterations Element (Microsoft Excel)

Specifies the maximum number of iterations when resolving circular references in Microsoft Excel.

Contained In

ExcelWorkbook

Remarks

This element contains a long integer value. If the Iteration element is specified, iterations are tracked, but if the MaxIterations element is not specified, the default maximum number of iterations is 100.

The MaxIterations element contains the maximum number of iterations allowed in resolving circular references, and the MaxChange element contains the maximum amount of change per iteration.

Example

See the example in the ExcelWorkbook element topic.