Mar 25

Circular References

If you purposely need to use a circular reference in a worksheet, make sure that you enable the Iteration option by choosing Tools | Options, click the Calculation tab, then toggle the Iteration checkbox. Otherwise, you'll repeatedly get error messages stating that Excel can't evaluate the formula.