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 2019 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 F6, and the value in cell F6 influences the value in cell A1. Figure 11-1 illustrates the pattern of a circular reference.

We see that cell A1 affects D3, D3 affects E6, and E6 affects A1, creating a circular loop in our spreadsheet logic.
Figure 11-1 ...

Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition 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.

Start your free trial