3

I'm an encountering a weird problem with Excel, and it's especially annoying because it wasn't happening yesterday, and hasn't happened ever before. Here's an explanation of what I'm doing:

  1. I copy a cell from a spreadsheet
  2. I paste the contents into a browser
  3. A bit later, I copy something from the browser and attempt to paste it into the spreadsheet

But what happens is that when I attempt to paste the text into the spreadsheet, I just end up pasting the data from the cell that I copied in step 1. It seems that the Office clipboard "takes over" or something. If I clear the selection (using ESC) it just thinks I have nothing copied at all.

Even weirder, if I open the Office clipboard, I can see the URL that I copied from the browser on there, and if I click on it and choose "paste", it pastes the data from the cell I had copied instead. It's like it gives that cell (which is still highlighted with the "ant trail") total priority over everything else.

I'm not sure why this started happening or what I can do to fix it. Any help would be appreciated!

Here's a brief gif I made that shows what I'm talking about.

https://i.gyazo.com/c5f87e5dc231e38f0ef30879a68dd0fb.mp4

I copy the cell with "cats" and paste it into notepad, then copy "asdf" from notepad but when I paste into excel again, it just pastes "cats".

Edit #2: I just remembered that my computer updated and restarted itself overnight, so I'd bet it has something to do with that. Doesn't look like there was a MS Office update though.

Mike
  • 39
  • 1
  • 1
  • 4
  • Does this behavior only happen in Excel? Can you copy and paste to and from Notepad.exe? – B540Glenn Apr 13 '17 at 18:30
  • 1
    Yeah, only Excel. Copying works as expected in Notepad and Word. – Mike Apr 13 '17 at 18:33
  • How about your control key? Is it stuck? Did you run a macro or other script that could have left your control key in the "pressed" condition? The only way I could replicate the behavior is while holding CTRL for all keystrokes. – B540Glenn Apr 13 '17 at 18:54
  • No, nothing like that... I found that what it's normally supposed to do is when I copying something from another program, Excel will "uncopy" the cell I had copied previously, and it won't be highlighted anymore, so I'll be able to paste the new thing I copied. But as you can see in the gif I posted, when I copy the text in Notepad, the cell in Excel remains highlighted. – Mike Apr 13 '17 at 20:04
  • 2
    https://superuser.com/questions/611854/prevent-excel-from-clearing-copied-data-for-pasting-after-certain-operations-w – ejbytes Apr 14 '17 at 05:50
  • 2
    https://support.office.com/en-us/article/Copy-and-paste-multiple-items-by-using-the-Office-Clipboard-714a72af-1ad4-450f-8708-c2931e73ec8a – ejbytes Apr 14 '17 at 05:51

1 Answers1

1

The "asdf" was never Copied to the Clipboard, Windows or otherwise. It was simply highlighted. Presumably Copied via a keyboard command as the mouse was not used for it. But it never made it to the Clipboard.

If I saw the GIF and in it the mouse right-clicked and chose "Copy" I'd see things differently. But that is not the case.

As to the "not Copied to the Clipboard" I have encountered times when I used Ctrl-C and then tried to paste to Excel, and to other programs, only to get the last thing I Copied before trying that copying. In those cases, I have never, in 30 years of using Windows, been able to get the keyboard copying to succeed. ONLY using the mouse breaks the impasse. After which, no problem, but without, no copying at all.

I believe that to be a mouse and Windows issue as it does not have to involve Excel. So I believe the same thing happened to the poster: he used the keyboard copying, but it did not occur, hence the "marching ants" never ceasing and accordingly getting the last thing Copied from Excel, not from Notepad.

As I believe it occurs in Windows and is a partial success of the process, but not the worthwhile portion at that, I see no problem with the partial success adding an entry to the Office Clipboard but failing before actually placing the desired material onto the Windows Clipboard, and therefore to the Office Clipboard: The process fails in between so you do not see the marching ants go away either, along with not replacing the contents with the new Copy.

Will be looking at that the next time I encounter this with Excel instead of another program.

Jeorje
  • 11
  • 1
  • If the Clipboard is changed, Excel detects this and automatically de-selects whatever that was being "copied". That's the first sign that the copy did not actually happen. – Nelson Nov 22 '21 at 07:19