O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. 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 Microsoft Office Excel 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 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 10-1 illustrates the pattern of a circular reference.

A loop causing a circular reference

Figure 10-1. A loop causing a circular reference ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required