Chapter 11. Circular References
I often get a circular reference message from Excel. Does this mean Iâve made an error?
How can I resolve circular references?
When you receive a message from Excel 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 C2, the value in cell C2 influences the value in cell D2, and the value in cell D2 influences the value in cell A1. Figure 11-1 illustrates the pattern of a circular reference.
Figure 11-1. Example of a loop causing a circular reference. ...
Get Microsoft® Excel 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.
