Excel file does not open due to circular references

     

Circular reference errors occur when a formula refers baông chồng lớn its own cell. For example, in the example shown, the formula in F7 is:


To resolve sầu circular references, you"ll need khổng lồ find the cell(s) with incorrect cell references & adjust as needed. The article below provides more information & steps khổng lồ resolve sầu.

Bạn đang xem: Excel file does not open due to circular references


Circular reference errors occur when a formula refers baông xã to lớn its own cell. For example, in the example shown, the formula in F7 is:


This creates a circular reference because the formula, entered in cell F7, refers khổng lồ F7. This in turn throws off other formula results in D7, C11, & D11:


=F7 // formula in C7=SUM(B7:C7) // formula in D7=SUM(C5:C9) // formula in C11=SUM(D5:D9) // formula in D11
Circular references can cause many problems (and a lot of confusion) because they may cause other formulas to lớn return zero, or a different incorrect result.

Xem thêm: Giáo Án Địa Lí 12 Cơ Bản Trọn Bộ, Bộ Giáo Án Địa Lí 12 Cơ Bản

The circular reference error message

When a circular reference occurs in a spreadsheet, you"ll see a warning like this:

"There are one or more circular references where a formula refers to lớn its own cell either directly or indirectly. This might cause them khổng lồ calculate incorrectly. Try removing or changing these references, or moving the formulas to lớn different cells."

*

This warning will appear sporadically while editing, or when a worksheet is opened.

Finding & fixing circular references

To resolve sầu circular references, you"ll need khổng lồ find the cell(s) with incorrect cell references và adjust as needed. However, unlike other errors (#N/A, #VALUE!, etc.) circular references don"t appear directly in the cell. To find the source of a circular reference error, use the Error Checking thực đơn on the Formulas tab of the ribbon.

*

Select the Circular References tác phẩm to see the source of circular references:

*

Below, the circular reference has been fixed & other formulas now return correct results: