Forum Discussion
If you thought Spills killed CSE, read this post
Yeah, just tried with a blank workbook and some VSTACKs, not noticeable. Meaning, your sheet needs a certain complexity. You'll know when it hits you. Just interesting to observe that CSE still has some use :)
I am a bit concerned about this. What level of complexity are we talking about? I have used SCAN to accumulate cash and debt as a two cell thunk over 30 years of monthly periods and then used the opening balances to generate a further 10 arrays using as a single array formula. No problems so far.
Are you working at a far bigger scale or is there something wrong with your setup that Excel is struggling to find the necessary resources.
BTW Before 2019 I used to use CSE to commit all formulas. It worked OK (though with some performance penalty) but authoring was not a good experience.