10-03-2017 09:54 AM
10-03-2017 09:54 AM
Sometime in the last few months the copy/paste function within Excel (Office 365 version) stopped working for me. I have updated Windows and all Office apps to the latest version but that hasn't fixed the problem. I've also run the Office 365
The symptom is very strange. When I hit Ctrl-C (or use the drop-down menus) on a cell in Excel the dashed lines that surround a cell selected for copying show up very briefly but immediately disappear. If I go to another cell and paste it just puts a open parenthesis "(" in the cell. Using Ctrl-X to cut exhibits similar behavior.
If I repeatedly hit Ctrl-C it will occasionally work (the dashed lines remain and I can paste) but it typically takes 15-20 tries before it will work and if I try again it will fail. This only seems to affect me when I try to copy cells. If I select a cell and then edit the cell and manually select the content of the cell I can copy and paste with no issue. It also appears to only be an issue when a cell is not empty. If I select an empty cell I can copy/paste just fine. If I select a cell that has been highlighted but has no content that also works properly. It's only when there's text or a formula in the cell that this is an issue.
This only affects Excel, I haven't observed the issue in any other app.
10-04-2017 02:40 AM
10-04-2017 09:25 AM
Thanks for the suggestion, I didn't even know safe mode was an option for Excel. Unfortunately it looks like that isn't the issue. I tried starting in safe mode and the same problem exists. Any other ideas?
10-04-2017 01:52 PM
At least clear what happens with dashed border - if clipboard doesn't work it dissappears.
Google says similar issue appears from time to time, for example https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17693512-after-upgrade-to-office... (by the way, you are on Mac or on PC?) or here https://answers.microsoft.com/en-us/office/forum/office_2016-excel/clipboard-problem-in-excel-2016/2....
But i didn't find concrete solution, sorry. I'd start from Office repair/update if that help.
10-04-2017 05:23 PM
Under the Home Ribbon, can you expand cell styles. Do you have something like this.. or are there many many odd formats..
10-04-2017 05:24 PM
Under the Home Ribbon, can you expand cell styles. Do you have something like this? or are there many many odd formats..
10-05-2017 09:09 AM
10-05-2017 10:02 AM
Jan, it looks like here clipboard is not locked by any other program. Even if external clipboard doesn't work Excel shall copy/paste within it, you only not able to copy/paste from Excel outside. Something is wrong within Excel.
However, above is only my guess, i could be wrong.
10-05-2017 10:46 AM
Correct, I don't think that's the case. I'm not getting an error that the clipboard is locked and the clipboard still functions correctly. ex. if I edit a comment I can select text, copy, and paste it inside or outside of excel just like I can select a formula in a cell and copy/paste it. I just can't copy/paste a cell.
10-09-2017 01:59 AM
10-11-2017 12:24 PM
Sorry for the delayed response, for some reason I didn't get a notification about another post so I just saw it when I came back and checked manually.
It's definitely not a keyboard issue. I have the same problem at home and at work and regardless of whether I'm using a docking station with external keyboard or built-in laptop keyboard.
Any other ideas? Excel is basically worthless if you can't copy and paste cells.
11-13-2017 11:54 AM
11-28-2017 01:10 PM
I am in the same boat.
I can copy/paste from Excel, to Excel.
I am unable to copy/past from OneNote to Excel.
This function was working fine a couple of weeks ago, and now it is not. I am also noticing a latency in Excel across all files.
12-04-2017 02:14 PM
I am also in the same boat.
Excel in Windows 10 slows down very frequently, even when only 1 workbook with no complex formulas is open.
The copy/paste function for cells is intermittent at best, you cannot copy a formula across multiple cells like you could in the past, and another unrelated issue: you can't delete a column or row that is under a merged cell at the beginning of the column or row like you could in the past.
01-28-2018 11:42 AM
I have the exact same problem on both my surface pro 4 and on my freshly formatted desktop pc.
In Excel 2016, I cannot copy any cells. The dashed lines will show briefly and then disappears.. A copied cell usually have the dashed lines circling it all the time.
When I try to paste, a left bracket shows up. " ( "
Can anyone help us solve this mysterious problem..?
01-29-2018 01:13 AM
01-29-2018 02:06 AM
Hi Jan, none of the methods work.
Below is a sample of my freshly formatted PC and freshly installed Microsoft Office 2016.
What I did was:
1) Select the A cell and press Ctrl+C
2) Select the B cell and press Ctrl+C
3) Select the C cell and press Ctrl+C
As you can see, there is this bracket ( somehow automatically copied on top of the A/B/C selections. This is really weird..
02-03-2018 07:07 PM
I have had the same problem, complicated by the "excel not responding" issue.
In an effort to solve that problem, I changed some settings under options.
Well, then my large workbook quit behaving nice. I would copy a row to one or more rows and all I got was the results from the copy reappearing in the new rows.
Well, that was cured with switching the calculations from manual to automatic. Fixed the copy paste problem! Did I feel dumb? You bet. I faintly remember using the manual calculation on a large worksheet from 20 years ago...
Now onto the "excel not responding" issue. I've been trying to dump tons of formatting (color, borders, etc.) and checking for those stray columns/rows that had accidental formatting. I saw that in one of my searches on google. It seems to help, except in the process, the message comes up again and sometimes doesn't clear for hours, even overnight. It's hard to dump formatting if you can't access the file and save your changes. I have been dealing with recovered files, multiple saves and so on. Sigh... I may have to start over with these files and recreate them. They are great grade calculators, with a sheet for each area (homework, attendance, quizzes, etc.) and pull into a summary page for final results. Lots of "vlookup" action between sheets. The fancy formatting with colors, borders, boxes helped to avoid errors with data entry. I teach large classes (100+) and this has evolved with each graduate assistant, computer, software change over the past 15 years. Probably quite a patchwork job by now. I might be on the road to sanity if all of this works.
I hope the manual to automatic switch in calculations works for you. Good luck. - Marie
02-07-2018 03:59 PM
I had the same problem. The only way I could copy cells was text only via the clipboard.
The solution for me was to disable (comment out) all macros and VB content I generated for that particular page. (I use a nifty little bit of code to insert the contents of a cell into the footer of the page.)
I did my copying and once the page was working I removed the comment ticks and everything worked.
Hope this helps..
02-25-2018 06:24 AM
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.
03-02-2018 01:40 PM
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.
03-03-2018 06:23 PM
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 !!
03-08-2018 02:01 PM
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?
03-10-2018 04:52 PMSolution
03-12-2018 04:12 AM
This problem is just because you have 2 instances of EXCEL.EXE and you want to copy paste from one instance to another. You can't copy paste values for example. You can see that from your Start Task Manager. In excel 2010 any workbook opened from explorer was opened from the last application opened. In 365 they try but from my experience sometimes fails to open all of them in only one application.
A solution is to open that excel file using File->Open commands inside your application and not double-clicking an excel file from explorer. I hope this helps.