![]() If cell A refers to cell B, and cell B refers to cell A, then you must break the circle, for example by making cell B refer to cell C instead of cell A.Īlternatively, you can replace one formula cell of the circle by using hard values. To remove unintentionally created circular references, you’ll need to correct the corresponding formulas. ![]() People often don’t intentionally create circular references instead, they usually result from formula errors. It also shows you the circular reference, with blue arrows pointing out the calculation chain for the circular reference. When you enter a formula that turns out to be part of a circular reference, Excel warns you with an error message. This list could potentially contain hundreds of cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |