January 2011
Beginner to intermediate
720 pages
23h 29m
English
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 2010 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 the value in cell A1. Figure 11-1 illustrates the pattern of a circular reference.

Figure 11-1. A loop ...