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
Edge Insider doesn't show notifications
ThatWeirdAndrew in Discussions on
10 Replies
Problem to start Teams in the browser
André Diekmann in Microsoft Teams on
9 Replies
SUM formula help needed with multiple criteria
Eileen Skidgel in Excel on
5 Replies
Help with #NUM error in IRR formula
hasan ahmed in Excel on
2 Replies