What Are Circular References in Excel and How to Manage Them
I'll explain what circular references are in Excel, why they occur, and how to handle them: they appear when a formula refers to its own cell, and knowing how to spot and resolve them will save you a lot of trouble.