How to fix a circular reference error in Excel

You’ve entered a formula in Excel, but it’s not working. Instead, you’ve got this message about a “circular reference.” Millions of people have the same problem, and it happens because your formula is trying to calculate itself, and you have a feature called iterative calculation turned off. Learn more at the Excel Help Center: https://support.office.com/excel