Forum Discussion
If you thought Spills killed CSE, read this post
I will take the warning but, to date, I haven't encountered such problems. Maybe the errors have caused some corruption of the Excel file. I have tried formulas such as
= LET(
date, EOMONTH(startDate, SEQUENCE(N, , 0)),
date
)
= LET(
flow, SEQUENCE(N, , initial),
flow
)
= LET(
balance, SCAN(0, cashFlow#, SUM),
balance
)
= SUM(cashFlow#)
= MAX(balance#)with N = 80,000 (quite a lot of months) with no apparent problem.
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.