Forum Discussion

Newton103's avatar
Newton103
Copper Contributor
Apr 28, 2020
Solved

Excel How to find circular formula

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 ?

excel
Formulas and Functions

5 Replies

  • Abiola1's avatar
    Abiola1
    MVP
    Apr 28, 2020
    In the Formulas tab > Formula Auditing > click on the little drop down beside Error Checking > Click on Circular References
    • Counter925's avatar
      Counter925
      Copper Contributor
      Apr 09, 2021
      Found it! Unnecessarily difficult to find for a long time, but infrequent Excel user.

      Thanks
      • Charles7_Titus-1's avatar
        Charles7_Titus-1
        Copper Contributor
        Dec 19, 2021
        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,

Resources