Paste Special Window opened using Keyboard shortcut not the active window

[MJGANAHL]

A couple of days ago on my work computer (Excel 2010), when I would open the Paste Special menu using the keyboard shortcut Alt+E+S, the window would open up, but it would not be the active window. It did not have a blue outline indicating it was the active window. I couldn't use either another keystroke ("V" to Paste Values) or the arrow keys to toggle between the Paste Special Choices. If I would somehow select the window (clicking with my mouse, Alt+tab, the windows key), then it would become active and I could use the menu normally. I have changed nothing that I'm aware of in the last couple of days (or the last couple of years for that matter) on my work computer and am baffled as to why Excel is acting this way. Would love to hear any suggestions! Thanks.

 

[jasonb75]

Not sure of the cause, another member had a problem with the same shortcut a few months back, although I don't think that it was the same problem.

I remember suggesting Ctrl Alt v, v as an alternative but the person who asked wasn't happy with that method so my apologies in advance if it's not what you need.

Another suggestion there was to use the context menu key then v, which I find less intuitive, but I think that is just down to the keyboard layout on my laptop.

 

[MJGANAHL]

It's funny. Your shortcut does work every time. I'm not sure why the shortcut I've been using for the last 20 years has now stopped fully working. There is still something else going on, but I guess I will leave it for another time....and will have to teach myself a different shortcut!

 

[jasonb75]

I'm not sure why the shortcut I've been using for the last 20 years has now stopped fully working.

That makes 2 of us, your method works fine for me.

Have you have any updates recently, installed any new add ins or other similar changes around the time it stopped working?

 

[TK5656]

Howdy - I've had the same issue. After googling, I found this link that sovled the problem for me. I was running Google Drive File Stream and had an option checked to show if users were in files editing them. I unchecked that option and it solved the problem for me.

Paste Special Shortcut Not Working (ALT + E + S)

Is anyone else having issues where when you try and for example, paste special values using ALT + E + S + V, it doesn't recognize that you are trying to hit V? What's happening is that when I copy a

answers.microsoft.com