LinkBack URL
About LinkBacks
As per the attached screen shot, i am not too sure why i have this arrow, and how can i get rid of it !
As per the attached screen shot, i am not too sure why i have this arrow, and how can i get rid of it !
One reason it could be there is because you have a circular refence.
If posting code please use code tags, see here.
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
Under Formulas, i click on remove arrows, it is gone, BUT, once i click save it appears again !
True it is the circular reference , and how can i turn it off ?
Attach an Excel workbook rather than a picture, and then we'll be able to see what is causing it.
Pete
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.
Attached is another screen shot that appears once i reopen the file.
As well, i have attached a copy of the file for assistance.
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.
Last edited by 6StringJazzer; 11-16-2012 at 02:13 PM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks