Copy Paste not working in Excel

Copper Contributor

Hi guys,

 

I've come across a problem with my excel.

 

I am copying over around 40 lines of figures at once to a new file but every time I paste the data, not all of them show up. I have used both the shortcuts (ctrl + c, ctrl v) and manually right clicking then pressing copy, right click then paste but doesnt work either.

 

I could copy 50 lines of figures and only 20 actually paste.

 

I have reset my pc multiple times but still nothing. 

 

Can anyone give me any solutions?

 

A13%     ||A13%
A23%     ||A2 
A3      ||A320%
A420%     ||A45%
A55%     ||A5 
A6      ||A6 
A7      ||A75%
A85%     ||A8 
A915%     ||A9 

 

The || is just a divider between the two tables. As you can see, a couple figures have deleted and have moved up in their places.

4 Replies

@usesrpf 

 

First we need to get a more thorough description of the symptoms, I think (I say that as someone who used to teach problem solving, technical problem solving, to scientists and engineers)...

 

So you've given an opening statement but here are further questions to help narrow down possible causes.

 

You've said 20 of as many as 50 rows of figures actually copy; that's a decent start.

It might be necessary to get more precise, but let's go with that for now.

  1. Are the rows that do copy (and those that don't) all together? Or are they randomly distributed among the ~~50 rows?
  2. Does this happen all the time? Does it happen only on this particular set of sheets, but Copy/Paste operates "normally" in other workbooks?
  3. Are the rows of figures consisting of cells with actual numbers in them, or are they formulas displaying as numbers?
  4. If you copy numbers singly rather than in bulk, can you take a number that doesn't copy when processed "in bulk" and succeed in copying and pasting it when you do it by itself?
  5. Are the numbers all positive numbers, a mix of positive and negative, financial figures, something else?
  6. Is the area in which you are pasting "virginal spreadsheet territory" or has it been occupied before by a previous set of numbers?

 

Let's go with those questions for now.  As you may have detected, each of those questions (depending on the answers) could lead to a different cause and therefore a different solution. That's why it would be premature to simply say "Do X and all your problems will be resolved."

@usesrpf 

I'm not sure but it could be the clipboard. Should be deleted / cleaned.

Clear the clipboard

https://support.microsoft.com/en-us/office/clear-the-clipboard-7afbf55f-d7d5-4096-87a0-eb17f821d321?...

 

With the Windows update to 1809, the multiple clipboard was introduced.

This can be activated and deactivated via "Settings -> System -> Clipboard".

You can open the clipboard history with [Windows key] + [V].

There you can delete individual copied sections by clicking on the "X" in the respective box. Alternatively, you can also clear the entire history using "Delete all".

 

If that doesn't work then CDM command.

Delete clipboard by command
Press the key combination [Windows] [R].
A small window will now open. Enter the following command there: cmd / c "echo off | clip".

Click OK to confirm.

The clipboard will then be automatically emptied.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@mathetes 

 

  1. What do you mean by all together? I select 50 rows of data, some rows could be blank or an actual figure but that shouldnt stop the copy paste.
  2. This has happened before but fixed itself after i shut down my laptop, i tried restarting but the problem persists. I do not use excel often - copying from excel to excel, mainly working on a singular excel.
  3. They are actual numbers, but even if they are formulas i could paste "As Values"
  4. Yes i could but it would take time in finding what number didnt get copied over. I have copied in segments so like every 5 - 10 rows but even this has the same copy paste problem. I would rather i find a solution to fix my bulk copy paste problem than use a slower method which would take more time and be prone to more mistakes.
  5. They are all percentages - no negatives.
  6. The column i paste all the data is blank.

 

I will update my post with a table with dummy data explaining my situation better.

@usesrpf 

 

First if all, let me explain a bit more what lies behind the questions. As I said in my first post, we needed a more complete description of the symptoms, as that's what's needed before the correct treatment can be determined. You presented an initial description only. You've now given a bit more complete description, with your image of rows copied and pasted, but at the time, we only knew that only about 20 out of as many as 50 were accurately copied.  So here's an analogous situation for your consideration, to illustrate the necessary process.

  • You go into the doctor's office with a complaint: "My left arm hurts. Please give me a solution (i.e., fix it)." Let's assume that your doctor has seen this morning five other people with left-arm-pains and they've all been sprains, treated by some pain killers and a routine of physical therapy. Would you want your doctor to prescribe that same treatment without further question?
  • I hope not. 
  • Left arm pain can be caused by multiple things: sunburn, sprains, abrasion on the skin, compression fractures, more complicated fractures, ... up to heart attack. To treat your complaint with the same treatment that worked for the last five patients would be malpractice. First we need to get the symptoms better defined. That might take one minute or less--just looking at the skin would take care of some of the possible causes--but it might take longer. And there'd be questions, physical probing--turn your arm right, now left; and possibly an EKG to eliminate (or confirm) the heart attack possibility if other questions pointed in that direction.

 

My questions were intended to serve that purpose of probing for how your complaint, "not copying consistently," more fully manifest itself. None of them were suggestions for treatment. So question #4, for example, was not how I was suggesting you resolve the problem, but a way of saying (back to the analogy) "turn your arm to the left, now to the right"....experimenting with a part of the situation, to try to undercover what could be going on.

 

Your situation is a tricky one to diagnose. Even your recreation of it just raises more questions, more possible causes.

 

That display, and the fact that rows sometimes move to a different row, relative to the origin, makes me wonder if there are hidden rows in the source data, or hidden columns. Is that possible?

 

@NikolinoDEhas suggested a treatment that may or may not be what's needed. Have you tried it? I've never heard it said that the clipboard itself might occasionally need to be cleaned. Worth trying.

 

Anyway, at this point, I'm wondering if you could post a copy of the actual Excel sheets. Working just with verbal descriptions, even with static images or representations, just isn't the same as seeing the actual "patient"  And please do it as a new posting in the chain, not as an edit to the original. That would help any other potential helpers here recreate the chain in its full chronological order.