Restore iterative formulas after an error

[Deleted]

Hi,

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

BR

E.