Following recent updates (Excel latest version and/or MacOS 14.5 ?), Excel crashes systematically on Mac OS 14.5, with a simple formula using BYCOL & INDIRECT:

=BYCOL(A3:E3;LAMBDA(col;INDIRECT(INDEX(col;1))))
with following data starting in A1

toto1toto2toto3toto4toto5     A1A2A3A4A5

my configuration : MacOS 14.5 on Macbook pro 16 with Apple M3 Max + Excel version 16.85 (24051214) with Microsoft 365 subscription
a few days ago (before latest updates) it wouldn’t crash.
Thanks for your support.

​Following recent updates (Excel latest version and/or MacOS 14.5 ?), Excel crashes systematically on Mac OS 14.5, with a simple formula using BYCOL & INDIRECT:=BYCOL(A3:E3;LAMBDA(col;INDIRECT(INDEX(col;1))))with following data starting in A1toto1toto2toto3toto4toto5     A1A2A3A4A5my configuration : MacOS 14.5 on Macbook pro 16 with Apple M3 Max + Excel version 16.85 (24051214) with Microsoft 365 subscriptiona few days ago (before latest updates) it wouldn’t crash.Thanks for your support.   Read More

​