How Do I Get Rid of a Circular Reference in Excel?
Identifying and Fixing Circular References The formula D1+D2+D3 lives in cell D3 and breaks because it’s trying to calculate itself. By moving the formula to another cell, you can fix the problem. Cut the formula with Ctrl+X, select a different cell, and paste it with Ctrl+V. Millions have faced the "circular reference" message due to … Read more