I posted an elaborate workaround that has been working for me on December 7 on this thread.
The potential problem is that Excel 365 memory cache conflicts with the Windows memory cache. In my case Win 11.
I use several combination of RAM clearing regularly throughout the session.
First, disingage Autosave. I manually and constantly back up my file every three or four minutes. I found that if I have it on autosave, it uses excess memory and slows down Excel performance. Also, the synchronization between the Cloud and the Windows desktop system run amok in its coordination. Remember, you are really not working in real-time on the desktop. Clouds apps only give you a limited parameter since they are conservative virtual machines assigned to your account. Cloud apps are an inconvenience compared to actual apps running on the desktop itself, moreover, it is a convenient income-making/cost-saving program for the company. I'm not sure why people like to put up with this delivery model. It is what it is.
Second, if I simply notice even a slight lag or glitch in the session, I clear all memory data from RAM. This should be done regularly regardless during the session.
Procedure:
- Clear (Clear All) the Clipboard located on the Excel ribbon.
- Save file.
- Clear the RAM through my Advance System Care (ASC) third-party app. I keep its RAM module floating on my desktop to determine how much RAM the system is using at a time. If it exceeds 60%, I clear it along with the other clearing procedures I have listed here. There may be other third party apps that perform a similar RAM clearing function other than using ASC.
- I also doubledown by clicking on my Clear Clipboard icon shortcut I created using Windows cmd function, i.e. cmd: /c echo.|clip. This function can be entered in the Windows Run prompt. However you are better off creating a shortcut using %windir%\System32\cmd.exe /c “echo off | clip." Just Right-click on Desktop and click on New and then chooseShortcut from the context menu. In the "What item would you like to create a shortcut for?" section, copy and paste the cmd line. Click Next, give it a filename, then click Finish. This beats having to manually enter into cmd mode to clear memory regularly.
- Once the RAM value drops to the average percentage of your Windows sessions (mine amounts to 45% RAM average use), I continue working.
This workaround becomes habitual once you start doing it. This procedure is the only one I have found to work consistently. I still get rare, occassional hiccups, but at least it prevents freezing Excel.
One more thing... close apps you are not using and Browser tabs not in use to avoid the swell-up of Windows RAM in the background.