Generally, if you have a circular reference (when a formula or function references itself), you’ll get an error message warning you about it. But the message doesn’t tell you where your circular reference is. And if you click Cancel on the message, it leaves the circular reference in the spreadsheet. So the question becomes, how do you find a circular reference in Excel?

Learn how: http://blogs.mccombs.utexas.edu/the-most/2012/06/22/find-circular-references-in-excel/

Posted by Alesi Gerthe