My circular ref sometimes works and sometimes doesn't

%3CLINGO-SUB%20id%3D%22lingo-sub-2870547%22%20slang%3D%22en-US%22%3EMy%20circular%20ref%20sometimes%20works%20and%20sometimes%20doesn't%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2870547%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20iterative%20calc%20enabled%20in%20excel%20as%20I%20have%20some%20circular%20references%2C%20but%203%20things%20can%20happen%3A%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ESometimes%20my%20circular%20reference%20gives%20me%20an%20answer%3C%2FLI%3E%3CLI%3ESometimes%20it%20shows%20%23NUM!%2C%20and%20I%20have%20to%20click%20into%20the%20cell%20containing%20the%20formula%20and%20press%20enter%2C%20for%20the%20iterative%20calc%20to%20show%20an%20answer%3C%2FLI%3E%3CLI%3Eand%20sometimes%20the%20above%20happens%20but%20it%20doesn't%20show%20me%20an%20answer%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20else%20have%20problems%20like%20this%3F%20Any%20clues%20on%20why%20or%20how%20to%20make%20sure%20the%202%20latter%20scenarios%20are%20mitigated%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankssss%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi guys 

 

I have iterative calc enabled in excel as I have some circular references, but 3 things can happen: 

  1. Sometimes my circular reference gives me an answer
  2. 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
  3. 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

0 Replies