Oct 20 2020 01:39 AM - edited Oct 21 2020 01:19 AM
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?
A1 | 3% | || | A1 | 3% |
A2 | 3% | || | A2 | |
A3 | || | A3 | 20% | |
A4 | 20% | || | A4 | 5% |
A5 | 5% | || | A5 | |
A6 | || | A6 | ||
A7 | || | A7 | 5% | |
A8 | 5% | || | A8 | |
A9 | 15% | || | 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.
Oct 20 2020 08:44 AM
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.
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."
Oct 20 2020 08:58 AM
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.
Oct 21 2020 01:12 AM
I will update my post with a table with dummy data explaining my situation better.
Oct 21 2020 07:45 AM
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.
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.