Forum Discussion

Aaron_Solomon's avatar
Aaron_Solomon
Copper Contributor
May 20, 2024

Excel crashing when combining BYCOL and INDIRECT

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...
Excel on Mac
Formulas and Functions
Aaron_Solomon's avatar
Aaron_Solomon
Copper Contributor
May 22, 2024

djclements, I checked the memory usage in the Activity Monitor, before loading the file, after loading the file, after un-commenting the formula so that Excel executes it : Excel memory usage never exceeds 1GByte. My Mac has 64Gbytes Ram and it seems plenty is available (>> 1 GByte), here is a screen capture of my Activity Monitor for the memory usage.

Aaron_Solomon's avatar
Aaron_Solomon
Copper Contributor
May 22, 2024

djclements, I checked on internet, it seems other are having the same issue. Following the recommendation provided on below thread where it's stated that similar problems are know issue with Excel 16.85, I downgraded to Excel 16.84 and the problem no more occurs. Thanks for your support !
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-crashes-on-certains-workbook-on-macos/ab3e2c65-a8c1-408d-bcc9-c9d523144eab?messageId=cbe94670-4c08-4f54-aa95-4daa1ea35a7b 

Resources