Circular references in Excel: What they are and how to fix them

Опубликовано: 31 Январь 2019
на канале: Microsoft 365
63,091
125

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