Using Circular References in Formulas
Overview
You can specify how the control calculates circular references used in formulas. A circular reference occurs when a formula uses the value in a cell to compute another value, which in turn is used by the first cell to recalculate its value. A simple example is if cell A1's value is equal to the formula B1+C1, and the value of cell C1 is equal to A1*3.
You can control the number of times the control calculates a circular reference.