Forum Discussion
Copy/paste no longer working in Excel
- I’d recommend that everyone having thus issue goes to File > Feedback and send a frown, putting your details in the section and start it [Can’t Copy Paste]
Also what version is everyone in who’s having this problem ? File > Account
It will read something like
Semi Annual Channel
Build 1234.567
Hi all,
I had this same issue and was disappointed to get to the bottom of the page with no answer.
However, upon saving & closing the most recent workbook I was working on, the copy paste functionality was restored in the new sheet I was working on that lost the ability to copy/paste.
This is really frustrating, but I think all we need to do is be a bit more organized and not leave workbooks open that we're not working on. That's my new protocol anyway. Hope this helps.
I have found the problem with copying from Excel cloud and to a local MAC screen i.e. a multi cell with a value to say notes.
The solution which is not one, but highlights the issue, is that you can double click on a value in Excel and copy from the bar, as below and it works 😩 but if I try and access and copy directly from the CELL it does not work at all, which is the existing problem. Not really a workaround, but does highlight what is going on !!
Thanks for the work around, Daniel. Works for me! Funny (?) thing is that I was having this problem in Libre Office and it appears to have been reported for years. It just started for me in Libre Office a few months ago. So I switched to Office 365 and same problem! My guess is it's not an Libre Office or 365 issue but some underlying issue with the way Windows handles copy & paste.
I haven't dug real deep, but in Libre Office the issue seems to happen when I copy something outside LO and try to paste it into LO. LO seems to hang on to the last item successfully pasted and not refresh with a more recent paste from Windows. 365 behaves the same for me.
Unlike the topic of this thread, I can copy/paste OK within 365 (or within LO). Hope this information is useful.
OK, guys none of these fixes worked for me. This just started for me today. In too different instances. When I copy the formula into another cell from another spreadsheet, the formula shows, but the result in the result from the cell I copied it from. he only that has worked is by going to insert function in each cell to "activate" the formula. I can't do this for hundreds of rows. How did I break Excel and what can I do to fix it?
- I’d recommend that everyone having thus issue goes to File > Feedback and send a frown, putting your details in the section and start it [Can’t Copy Paste]
Also what version is everyone in who’s having this problem ? File > Account
It will read something like
Semi Annual Channel
Build 1234.567Wyn Hopkins In my opinion when i had this problem today, copying and pasting from between Excel and UltraStudios text editor for example, to resolve this in Excel I clicked the small Clipboard button
Thats the tiny grey button bottom right corner of the image above in the Home ribbon bar "Clipboard"
Any then on the bottom left corner of Excel
Make sure its set with "Show Office Clipboard Automatically" checked and "Collect Without Showing Office Clipboard" and then it began to behave properly, copying and pasting in and out of excel, no more issues.
HTH
