I have a quite big issue with a iterative calculation.
I have a huge excel files (more than 15 Mb in size) with some circular references.
To overcome the circular reference error I have activated iterative calculation and all formulas and data update smoothly.
Unfortunately if some of the input data results to be "N/D" (because are looked-up from another table), the formulas interested by iterative calculation turns to ND as well and no update in any way.
I tried recalculating all formulas many times (F9, CTRL- SHIFT - ALT F9) but nothing.
Many thanks for your precious support