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 off...
excel
Formulas and Functions
  • Newton103's avatar
    Newton103
    Apr 28, 2020

    Abiola1   Found it. Many thanks

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,
  • Newton103's avatar
    Newton103
    Copper Contributor
    Apr 28, 2020

    Abiola1   Found it. Many thanks

Resources