-
Blue Line in Excel
about 9 years ago
-
about 9 years ago
Hi, the blue line usually indicates a circular reference between 2 cells. So if a cell A1 has a formula which references cell A5 and the cell A5 contains a formula which references A1 then this indicates a circular reference and the 2 cells will be connected by this blue line
-
-
about 9 years ago
Apurva, thanks. I was able to sort it. File- Options- Formula- Enable Iterative Calculation.
-
2 Answer(s)