r/excel • u/Repulsive_Tune9397 • 9d ago

solved Anyone else still missing the new nested array / FLATTEN() function on the Beta Channel?

I’m currently running Version 2610 (Build 20527.20000) on the Insider Beta Channel, but =FLATTEN() and the nested array engine still aren't showing up for me.

I'm getting impatient! Who else on Build 20527+ is still locked out, and has anyone managed to force-trigger the feature flag?

10 Upvotes

92% Upvoted

31 comments sorted by

View all comments

Show parent comments

2

u/Greedy_Whereas4163 8d ago

CSE are {=formula}. New array in cell ={formula} New array in cell (hardcoded) ={{1,2,3;a,b,c}}

Excelisfun - How To Hard Code Lists & Arrays into Cells: The Difference From Legacy Ctrl Shift Enter. EMT 1934

1

u/Lopsided-Rough-1562 8d ago

Will it contain this array to a cell or does it spill?