•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Nested arrays UI just showed up in Excel Beta (v2604 19901.20000)… but it’s broken?
Our take
A new UI element for nested arrays has appeared in Excel Beta (v2604, Build 19901.20000), sparking curiosity among users. This feature aims to address the limitations of the current “#CALC!” error associated with nested arrays, offering a more intuitive approach for data management. However, many users, including myself, are finding that the button is currently non-functional. If you’re also on this version and can replicate the issue or have successfully used the feature, please share your insights on its intended functionality and output behavior.
I’m on Excel Beta Channel Version 2604 (Build 19901.20000) and this morning I noticed a new UI “button”/surface that strongly looks like it’s for nested arrays support.
Right now the button seems broken (at least for me), but the intent is clearly there. instead of the current “#CALC! nested array” limitation we’ve all worked around in REDUCE+V/HSTACK land.
If anyone else is on v2604 build 19901.20000 and can reproduce (or gets it working), can you share what it’s supposed to do / where it writes output / what formulas it affects?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience