Circular Reference/Iterations

[millhouse123]

I have a workbook with 30 worksheets, each one is dependant on the others for a calculation. This in turn creates a circular reference, I have turned on interations but The problem I am having is that it keeps throwing errors (#NA) which then causes errors throught the workbook. I am looking for suggestions on the best way to handle this. I tried using iferorr but that just changed the error cells to zero's which is not correct.

Thanks in adavance for suggestions.

 

[Robert Mika]

Hi millhosue,
Would it be not a good idea to get rid of this circular references.
If they still exist that means that Excel has reached its limit of calcualation.
Lokk here for soem advice:

http://www.decisionmodels.com/calcsecretsk.htm

 

[gobobbygo]

Would it be not a good idea to get rid of this circular references.
If they still exist that means that Excel has reached its limit of calcualation.
http://www.decisionmodels.com/calcsecretsk.htm

Does this reference to "limit of calculation" mean that it is possible to overextend excel such that circular reference warnings appear when, in fact, there are none?

I have a big workbook with such warnings, that disappear when a seemingly innocuous cell gets cleared, a cell with no formulas in it.