Excel won't "uncopy" a copied cell after I copy something else

[mikeshinobi]

I know the title probably sounds weird, but I'm not sure how else to phrase it!

If I copy a cell in Excel, and then copy something else from a different application, if I try to paste in Excel it will paste the contents of the cell I copied previously instead of the thing I copied in the other application. Additionally, the cell I had copied previously is still highlighted with the "marching ants".

Normally if you copy something in a different application after having copied a cell in Excel, Excel will "uncopy" that cell ie. the cell will no longer be highlighted/have the marching ants. And thus, you're able to paste whatever you copied in the other application into Excel.

Here's a .gif I made to show what's happening. I only had 7 seconds, so I had to be quick!

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

I copy the cell containing "cats", and paste it into Notepad. Then I type asdf into Notepad and copy that, but as you'll see the cell remains highlighted, and when I try to paste into Excel, it just pastes "cats".

For some reason it only started doing this just today. It's been working just as it should for the past, well, forever. I don't know what could have happened that would be making it do this!

 

[Roderick_E]

I know the title probably sounds weird, but I'm not sure how else to phrase it!

If I copy a cell in Excel, and then copy something else from a different application, if I try to paste in Excel it will paste the contents of the cell I copied previously instead of the thing I copied in the other application. Additionally, the cell I had copied previously is still highlighted with the "marching ants".

Normally if you copy something in a different application after having copied a cell in Excel, Excel will "uncopy" that cell ie. the cell will no longer be highlighted/have the marching ants. And thus, you're able to paste whatever you copied in the other application into Excel.

Here's a .gif I made to show what's happening. I only had 7 seconds, so I had to be quick!

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

I copy the cell containing "cats", and paste it into Notepad. Then I type asdf into Notepad and copy that, but as you'll see the cell remains highlighted, and when I try to paste into Excel, it just pastes "cats".

For some reason it only started doing this just today. It's been working just as it should for the past, well, forever. I don't know what could have happened that would be making it do this!

Let's clear your clipboard

open a blank Excel session, press Alt+F11, insert, module, paste the following into the big blank white area.

sub clearit
Application.CutCopyMode = False
msgbox "Presto!"
end sub

then click the RUN and run it. If all goes well, the issue should be gone,