Windows 11 Excel VBA Paste Error Every Time

[cbrendlinger]

We just upgraded all of our computers to Windows 11. I have a macro used on multiple computers and have had no issues on all of them but one. That one cannot run the macro (or any macro) that includes a paste of any kind. I have tried the simplest copy and paste and it fails. Excel throws a runtime error 1004 "We couldn't paste the data because it took too long. Try reducing the size of the selection." I cannot tell you the number of iterations and ways to paste using VBA that I have tried... but no joy. I even tried adding a 5 second pause before the PASTE in case the program needed to catch up but still the error. Yet... if I add a MsgBox just before the PASTE, it works (but that is really not feasible). I have been checking settings and everything I can think of but there is nothing that stands out. We have done repairs and deep repairs and nada. If anyone can provide insight of any kind, believe me, I am willing to try. Thank you in advance

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel VBA Runtime Error 1004 on every Paste
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.