A circular dependency means a calculation eventually depends on its own result. Trace the loop before changing workbook settings or replacing the error with a fixed value.
Follow the dependency chain
Inspect the formula and its referenced cells. A direct example is a total in B10 using a range that includes B10 itself. An indirect loop can pass through other cells or tabs before returning to the starting cell.
Write down which cells are inputs and which are outputs. If a result is accidentally included in its own source range, correct that boundary rather than moving unrelated records.
Separate accidental loops from a designed model
Most ordinary totals and lookups should have a clear direction from source data to result. A calculation that feeds back into itself may reflect a misplaced reference or a model whose assumptions need review.
Do not enable an iterative-calculation option merely because an error message mentions a loop. A deliberately iterative model requires an understood convergence method, stopping criteria, and independent checks; availability of a setting does not establish that the model is valid.
Verify the repaired calculation
Check the result against a small example with known inputs. Change one input and confirm the output responds correctly. Review dependent summaries for hard-coded workarounds that may have been added while the loop existed.
Preserve the original formula and a recoverable version before redesigning a complex model. Calculation settings apply to the spreadsheet, so a change can affect other collaborators and formulas. A visible result after a settings change is not proof that the dependency was resolved or that the number represents a stable, meaningful calculation.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.