Locate a Circular Reference : Circular Reference « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Circular Reference
Click the Formulas tab. 
           Click the Error Checking button arrow. 
           Point to Circular References. 
           Then click the first cell listed in the submenu.
Click the Formulas tab. Click the Error Checking button arrow. Point to Circular References. Then click the first cell listed in the submenu.
Review the formula cell. 
           And continue to review and correct the circular reference until the status bar no longer displays the word "Circular."
Continue to review and correct the circular reference until the status bar no longer displays the word Circular.








6.5.Circular Reference
6.5.1.Locate a Circular ReferenceLocate a Circular Reference
6.5.2.Enable and increase formula iterations to make a circular reference workEnable and increase formula iterations to make a circular reference work