Chapter 11. Circular references
Questions answered in this chapter:
I often get a circular-reference message from Excel. Does this mean I’ve made an error?
How can I resolve circular references?
When Microsoft Excel 2016 displays a message that your workbook contains a circular reference, it means there is a loop, or dependency, between two or more cells in a worksheet. For example, a circular reference occurs if the value in cell A1 influences the value in D3, the value in cell D3 influences the value in cell E6, and the value in cell E6 influences ...
Get Microsoft Excel 2016 Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
