Hi guys
I have iterative calc enabled in excel as I have some circular references, but 3 things can happen:
- Sometimes my circular reference gives me an answer
- Sometimes it shows #NUM!, and I have to click into the cell containing the formula and press enter, for the iterative calc to show an answer
- and sometimes the above happens but it doesn't show me an answer
Does anyone else have problems like this? Any clues on why or how to make sure the 2 latter scenarios are mitigated?
Thankssss
