![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 42%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 90%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQQ%3C/text%3E%3C/svg%3E)
Dear dave Retail,
A circular reference occurs when a formula refers to its own cell either directly or indirectly, including through dependencies in other formulas. In some cases, functions like NOW() or dependent calculations elsewhere in the workbook can create an indirect link back to the originating cell, triggering the warning. Updates to Excel’s calculation engine may also cause previously unnoticed indirect references to be flagged.
We recommend the following steps:
Use Formulas > Error Checking > Circular References to identify all cells involved in the dependency chain.
Check related formulas in AA85 and any other cells that may reference H85, even indirectly.
If the circular reference is intentional, enable iterative calculation via File > Options > Formulas, and set appropriate maximum iterations and change values.
If unintentional, adjust the formula or move it to a cell that is not part of the dependency loop.
Please share a sample of the relevant cells’ formulas if you would like us to help trace the dependency path and suggest a corrected formula.
If my answer is useful for you, please vote for it.
Best regards,
Quinnie Quoc.