Another Excel 2007 problem.

[onenormalman]

Anyone can show me how to get rid of this error message:

"One or more formulas contain a circular reference and may not calculate correctly. Circular references are any reference within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that refers to another cell which depend on the original cell's value both contain circular references. For more information about understanding, finding, and removing circular reference, click OK. If you want to create a circular reference, click Cancel."


I just close it and it's still working fine. Should I click OK or Cancel? And if doing so will it be a problem with other formula?

 

[mayest]

Well, you've got a circular reference and that is most likely a problem. You can enable iterative calculations if you meant for that formula to be circular, but you probably didn't. So, you should find the offending formula (look in the status bar, when you are on the correct sheet it will say something like: Circular F28, so F28 is where you should start looking) and fix it. If you click Ok when you get that message, Excel will try to help you find the problem.