SOLVED

Excel How to find circular formula

Copper Contributor

Each time I switch a certain spreadsheet on I see a message telling me that it includes a Circular Reference in a formula, but it doesn't tell me where.  It's a large s/sheet.  How can I find the offending formula cell ?

5 Replies
In the Formulas tab > Formula Auditing > click on the little drop down beside Error Checking > Click on Circular References
best response confirmed by Newton103 (Copper Contributor)
Solution

@Abiola1   Found it. Many thanks

Found it! Unnecessarily difficult to find for a long time, but infrequent Excel user.

Thanks
I have 26 pages on the file I have tried going through each sheet checking circular error and error checking. I cannot find the circular error,
Never mind I found it. Patience finally rewarded.
1 best response

Accepted Solutions
best response confirmed by Newton103 (Copper Contributor)
Solution

@Abiola1   Found it. Many thanks

View solution in original post