Microsoft Office Tutorials and References
In Depth Information
Locating Circular References
Did You Know?
You can enable and increase formula iterations to make a circular
reference work. Click the File tab, click Options, click Formulas, select
the Enable iterative calculation check box, enter the maximum number
of iterations you want (higher the number, the more time Excel needs
to calculate a worksheet), and set the maximum amount of change you
want to accept between calculation results (smaller the number, the
more accurate the results).