Tuesday 11 September 2012

Locate a 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.

No comments:

Post a Comment