Restore iterative formulas after an error

%3CLINGO-SUB%20id%3D%22lingo-sub-324356%22%20slang%3D%22en-US%22%3ERestore%20iterative%20formulas%20after%20an%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324356%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20quite%20big%20issue%20with%20a%20iterative%20calculation.%3C%2FP%3E%3CP%3EI%20have%20a%20huge%20excel%20files%20(more%20than%2015%20Mb%20in%20size)%20with%20some%20circular%20references.%3C%2FP%3E%3CP%3ETo%20overcome%20the%20circular%20reference%20error%20I%20have%20activated%20iterative%20calculation%20and%20all%20formulas%20and%20data%20update%20smoothly.%3C%2FP%3E%3CP%3EUnfortunately%20if%20some%20of%20the%20input%20data%20results%20to%20be%20%22N%2FD%22%20(because%20are%20looked-up%20from%20another%20table)%2C%20the%20formulas%20interested%20by%20iterative%20calculation%20turns%20to%20ND%20as%20well%20and%20no%20update%20in%20any%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20recalculating%20all%20formulas%20many%20times%20(F9%2C%20CTRL-%20SHIFT%20-%20ALT%20F9)%20but%20nothing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20your%20precious%20support%3C%2FP%3E%3CP%3EBR%3C%2FP%3E%3CP%3EE.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-324356%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Deleted
Not applicable

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. 

0 Replies