Forum Discussion
Circular References in Excel
When I open a couple of my spreadsheets, I get the following warning: "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might ca...
Thank you, Hans. I just now have found your reply. What is the "Formula Auditing Group" and how do I find it? Also, these are workbooks that have multiple worksheets. Do I need to perform the "formula audit" on each sheet individually to locate the circular reference(s)?
Thanks again. Everett
On the Formulas tab of the ribbon, click Error Checking > Circular References. You should see a flyout menu with the cells on the active sheet that have circular references.
You'll have to do this for each sheet individually, I'm afraid.
- Thank you for the visual. Yes, finding them now! Thanks again for the help.