Home

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
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. 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies