My previous laptop (which had some great specs) I noticed that when Excel Memory Usage rose above 1,800 MB that it would start behaving badly and do really random weird stuff (Example: Randomly freeze for short periods of time, click in a cell and it does not recognize that you clicked on it, but the data is in the formula bar, and you can change it. These are just two off the top of my head, there are many other random things as well).
Now I have a new laptop with amazing specs, and I am using Microsoft Office 365 Enterprise 4 64-Bit version with the latest updates installed. I am still noticing that Excel is having issues when the Excel program memory goes above 1,800 MB. What is the deal? Does Excel have a limit on how much memory it uses? I did check my options and I'm using all threads with no limits listed.
Is there a way to increase this limitation, if in fact one does exist?
My Lap specs are;
AMD Ryzen 7 PRO 7840U 8 Cores, 16 Threads
Ram Memory 32 GB
Microsoft Win 10 Pro
Lenovo ThinkPad T16 Gen 2