Many people pop up "circular reference warnings" frequently when they open Excel. What's the cause? How do I stop the pop-up? Please see the solution below.
How do excel always eject a circular reference warning? How to solve
Reason: The object referenced by the formula refers directly or indirectly to the current cell itself. So give a false reminder.
A circular reference is a reference to itself, directly or indirectly, in an Excel formula, as in the following formula
The sum common set in C10 =sum (C6:C10) ' C10 includes itself
When a table contains a circular reference, every time you open the table, a prompt appears, as shown in the following figure.
How can I quickly find the formula address for a circular reference?
Methods: Formula tab-Error checking-circular reference-click the address to jump to the cell where the circular reference is located.