How to slove: Circular Reference Warning

  • Thread starter Thread starter Rasoul Khoshravan
  • Start date Start date
R

Rasoul Khoshravan

I made a wrong step inside my worksheet and got a "Circular Reference
Warning" and all relevant cells become "Ref!"
I corrected it but now whenever I open same file, again I get
following error message:

Circular Reference Warning
One or more for,ulas contain a circular reference and may not
calculate correctly.

I searched whole tabs, but couldn't find any bug.

How can I solve the issue not to face the same error message again?
 
I made a wrong step inside my worksheet and got a "Circular Reference
Warning" and all relevant cells become "Ref!"
I corrected it but now whenever I open same file, again I get
following error message:

Circular Reference Warning
One or more for,ulas contain a circular reference and may not
calculate correctly.

I searched whole tabs, but couldn't find any bug.

How can I solve the issue not to face the same error message again?
Click to expand...

hi
a circular reference means that one of your formulas is referring back
to itself either directly or indirectly. you will have to find that
formula and correct it.
you didn't say which version excel you have. i'm retired now and stuck
with 03.
in 03, click tools>customize>toolbar tab then check the circular
reference. the circular reference toolbar should display a list of
formulas in the circular reference. you may have to do some hunting
from here to find the suspect formula.
in 07, click office button> excel options>customize. not sure from
here. snoop.
but to clear the circular reference message, you must clear the
circular reference.

regards and good luck.
FSt1
 
Back
Top