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.

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

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ole Tom" wrote:

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.

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

Ole Tom wrote:

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.

--

Dave Peterson