Forum Discussion
Copy/paste no longer working in Excel
- Mar 11, 2018I’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
I have had this same issue in all Microsoft Office products, and I just had the same issue happen in OpenOffice Draw! It seems to happen with a document that I have been editing over and over again. Opening a new document does not seem to help the issue.
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.
- Daniel BennettMar 04, 2018Copper Contributor
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 !!
- David_ReichardDec 12, 2022Copper Contributor
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.
- Glenn Scott-MeltonMar 08, 2018Copper Contributor
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?
- Wyn HopkinsMar 11, 2018MVPI’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