Quick answer
A circular reference occurs when a formula depends on its own result, directly or through other cells. Trace the dependency and correct the formula instead of switching on iterative calculation as a quick workaround.
Understand the problem before changing anything
A total placed in F3 with =SUM(A3:F3) includes itself. A less obvious loop can run from one worksheet through another and back again. The displayed value may be zero or an earlier result, so a plausible number is not proof of correctness.
Step-by-step checks
Save a separate working copy
Preserve the original formulas before troubleshooting a shared or important workbook. Note the circular-reference warning and any cell address shown.
Find a reported reference
In desktop Excel, use Formulas > Error Checking > Circular References where available. Visit each listed cell and inspect the full formula.
Trace the loop
Check precedents, named ranges and formulas on other sheets. Write down the path until you find where a calculation feeds its own input.
Correct the dependency
Exclude the total cell from a sum range, move the result outside the source range or separate an input from an output. Recheck adjacent copied formulas.
Recalculate and compare
Confirm that the warning disappears and compare key totals against a small manual example. Resolve remaining circular cells one at a time.
What to avoid
Iterative calculation is appropriate only for a model intentionally designed around convergence. It can conceal an accidental loop and introduce results that depend on calculation settings.
How to verify the result
Use a simple known input to check the repaired calculation. Verify that no remaining circular references exist after saving and reopening the copy.
Check the workbook’s structure as well as the visible result
Work on a separate copy when the workbook supports invoices, stock, payroll or a shared report. A cell’s appearance is only one layer: its stored value, formula, number format and validation rule can differ. Record the affected worksheet and one example cell so you can compare the same case after each change.
Use a small, known example to test the intended behaviour. Check one ordinary row, one blank and one unusual value rather than judging a whole report from its grand total. If the workbook imports data, correct the import or source definition where possible; repeatedly correcting the final display can leave the same problem waiting for the next refresh.
Before sharing the result, check formulas that depend on the changed area and any charts or PivotTables fed by it. Save, close and reopen a working copy, then verify the same example. Mention any deliberate conversion of text, dates or identifiers so another user does not reverse it accidentally. If a colleague owns the workbook, agree changes to validation, protection and calculation settings rather than silently changing the model.
Before you finish
- Affected sheet and sample cell
- Original value compared with expected value
- Source, formula and display checked separately
- Dependent reports tested after saving
Common question
Why did the warning disappear but totals remain wrong?
Removing one loop does not prove every formula is correct. Check the intended range, other errors and whether copied formulas still reference the right inputs.
Need help with the next step?
Tell RJ Computers the device model, exact symptom, checks already tried and whether important files are backed up. Confirm availability, assessment charges and the scope of work before arranging a visit.
Reference and version notes
Check the official instructions for your exact product version; menu names and available features can differ.
Official product documentation