A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Thank you so much! Turning off Live Preview did the trick!
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.
Thank you so much! Turning off Live Preview did the trick!
I haven't used that functionality so can't answer your question. My original post identified that, as often as not, Copy would throw up an error message.
Things are a lot better now, since if you get the error message you can Cancel it and repeat the Copy. It then works. Maybe one day they'll get rid of the error completely.
Does this have anything to do with opening two sheets of the same workbook (view then new window) and copy and pasting withing those sheets. This is usually when it happens to me. Two different memory spaces within the same workbook?
Same here. This has been a thorn in my side for years and across at least 6 machines!
Insane answer
solution:
command prompt
echo off | clip
you should have added the words "MIC DROP!" LOL
This worked! Well...as of right now, so far! I cannot believe it! I've been searching for a solution and this error has even stumped our IT team!
Just by mere chance, we came across your solution and tried it! Dang!
Yeah, definitely an INSANE ANSWER!
HUGE HUGE THANK YOU!