A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
why don't we just diable copy and paste? that will do the trick as well.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Win 10 version 21H2 Build 19044.1706
Excel 2016 Version 2204 Build 15128.20224
This problem occurs randomly and with only a few cells being copied. The spreadsheet locks up and the only way out is Save>Close and open the book again. Sometimes that doesn't work and I have to close Excel completely.
Sometimes the top ribbon completely greys out and I can't do anything.
This is becoming a significant problem.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
why don't we just diable copy and paste? that will do the trick as well.
That did the trick.
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:
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.
I'm not even trying to use the clipboard and it's doing this. It's a major PITA.
Mine has always been unchecked.