Circular Reference ?

[zone709]

Hi, My friend sent me an excel sheet. I opened it up and get There are one or more Circular References. I see he sent me the sheet from a 97-2003 .xlsx. I am on a 2016 so i re saved is and it went away, but now i opened it again and it came back. Is there anything else i can do to stop this from happening? thank you

 

[Zot]

Need to find out the root cause ?

Remove or allow a circular reference - Microsoft Support

Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

support.microsoft.com

 

[zone709]

Need to find out the root cause ?

Remove or allow a circular reference - Microsoft Support

Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

support.microsoft.com

Thanks I got it. The fix was under File , options Formulas then Enable iterative calculation had to be checked.

 

[Zot]

Thanks I got it. The fix was under File , options Formulas then Enable iterative calculation had to be checked.

 

[Alex Blakenburg]

Thanks I got it. The fix was under File , options Formulas then Enable iterative calculation had to be checked.

Unless you are doing something that requires an iterative formula eg a goal seek model, Enabling iterative calculations is a really bad idea.
You really need to be tracking down and fixing the circular references.

A circular reference is indicative of an error in the formula and enabling iterative calculations is just hiding the errors in the formulas.
This link may help you resolve them:
Circular reference in Excel: how to find, enable, use, or remove - Ablebits.com
There is a macro on ExcelTips that may also help identify the circular references
Find circular references within your workbook