Why is Excel so slow/freezes on my Mac?
I have a Macbook pro 2017 with macOS Monterey and Microsoft Excel 2022 Version 16.63.1 (Microsoft 365 subscription) running. Whenever I try to use any formulas for multiple rows in excel, it takes a lot of time to process and sometimes even stops responding. I used the same spreadsheet on a windows laptop and it works fine. I had no such issues in the past. It kept on crashing whenever I used a if and statement or xlookup the the other day. I tried it multiple times and currently excel says its calculating and shows 80% but I had it running since yesterday night. What's the issue here: OS, processor, RAM or excel itself?