how to solve excel error circular reference

[chingg1011]

hi excel expert

my excel file recently come up an error circular reference (pop up message).

may I know how to solve it out by the step?

Thanks
Dennis

 

[Kaper]

if it worked before and suddenly appeared, there is a big chance, that you moved a cell with a formula into a range which is (may be indirectly) referred in this formula.

Check if UnDo (ctrl+Z) is available.
If it is not, step by step analysis of a cell marked as containing error generating formula will be needed. You may use tools like Trace precedents (and possibly trace dependants) from tab Formula, group Formula Auditing

 

[myall_blues]

In addition the status bar tells you where the circular references are.