over 5 years ago
Can anyone tell what is this blue line I am seeing in my excel?
This excel has lot of data and formula.
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
Apurva, thanks. I was able to sort it.
File- Options- Formula- Enable Iterative Calculation.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using