How do I correct a complex circular reference?

[Guest]

I have a circular reference in cell L12. The formula in the cell is:
=sum(L8:L11).
The result in L12 is used by about 8 other cells to make decisions. The cell
computes how many contracts to initiate based four different formulas in
cells 8:11.

Thank you for any clues as to how to resolve the conflict.

 

[Guest]

Something almost has to be reffering to that cell to get some data that you
are summing.

Try Tools->Formula Auditing and look at the precedents and more importantly
the dependents for that cell. Trace you logic and make sure none of those
8-11 are there because of a formula utilizing L12

 

[Dave Peterson]

You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip