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've had similar issues in the desktop version of Microsoft Office Professional Plus 2010. I first noticed that Excel would not drag-and-drop from cell to cell. I couldn't paste in, any capacity, within a workbook either. However, I could copy from Excel and Paste to another program(BluBeam/Adobe), just not another Office program. Which lead me to discover the problem existed across all the Office programs I had open.
I closed ALL Microsoft Office programs and re-opened them and the copy-paste functionality returned for all of them.
I've just come across this issue in Excel on a colleague's computer, running Windows10.
What we found as a workaround was that selecting the required range, holding Ctrl and dragging the entire frame from workbook A to workbook B successfully copied the range. It helped that we were working on a dual screen.
Normal copy & paste, using either Ctrl+C/Ctrl+V or right click did not work. As soon as we clicked on workbook B, the dotted lines from workbook A disappeared and the paste function reverted to pasting some text that had been copied elsewhere earlier in the day.