Blue Arrow on my screen

[Oceans]

As per the attached screen shot, i am not too sure why i have this arrow, and how can i get rid of it !

[Norie]

One reason it could be there is because you have a circular refence.

[Pete_UK]

That looks like the arrow you get when you have a circular reference error - did Excel not flag this up and open the Help screen at the circular reference section?

If I'm correct, then you need to get rid of the circular reference, but we can't help you much more with just a picture to go on.

Hope this helps.

Pete

[Oceans]

True it is the circular reference , and how can i turn it off ?

[Pete_UK]

Attach an Excel workbook rather than a picture, and then we'll be able to see what is causing it.

Pete

[Oceans]

Under Formulas, i click on remove arrows, it is gone, BUT, once i click save it appears again !

[Norie]

You can goto Formulas and select Remove Arrows from the Formula Auditing section.

That will hide the arrow but it won't get rid of the problem.

[Oceans]

Attached is another screen shot that appears once i reopen the file.


As well, i have attached a copy of the file for assistance.

[6StringJazzer]

In K5 you have

=COUNTIF(K7:K3994, "<>")

and in K9 you have

=IF(AND(K5=K6,K6=K7),"OK","Error")

K9 refers to K5 in an equality test, and K5 refers to K9 for a content test. That's circular. Can you rewrite the K5 formula to look only at the cells you really need to evaluate? From this sheet it is not at all clear what you are looking for in that COUNTIF, since there is no data or formulas past row 9.

Edit: The same problem occurs in multiple columns.

[Oceans]

i appreciate your feedback, K5 was supposed to be value not formula, i guess it did not paste as value from another sheet, K9 is the cell that supposed to be formula to validate the K column.
So now it is clear for me why and how to resolve it.
Much appreciated.