Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Melt
--
Chapters
00:00 Prevent Excel From Clearing Copied Data For Pasting, After Certain Operations, Without Office Clipbo
01:11 Answer 1 Score 4
01:22 Accepted Answer Score 49
02:36 Answer 3 Score 4
03:01 Thank you
--
Full question
https://superuser.com/questions/611854/p...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel #microsoftexcel2010 #clipboard
#avk47
ACCEPTED ANSWER
Score 49
The answer, unfortunately, is no, you can't stop this from happening.
As described by Joel Spolsky, developer and program manager for excel:
The official reason is that Excel doesn't really have cut and paste, it has move and copy. That's necessary because Excel automatically does reference fix up. For example, if cell A2 is defined as =A1, and you move cell A1 to A3, cell A2 will be updated to =A3.
If Excel actually cut things to the clipboard you would somehow need to have a reference pointing >into< the clipboard which is bizarre and for which there is no reasonable syntax. In other words, Excel doesn't want to leave you with dangling references during a move operation and isn't confident that it would be able to fix them up correctly when you completed the move by selecting "Paste."
Joel Spolsky 3/9/2004
What this means is that because of the difficulty inherent in the way excel maintains references, at the time of development there was no good way to store these references outside of excel and have them remain dynamic to be re-inserted. Once you change focus excel's ability to retain your original references is lost.
Unfortunately, MS does not consider this a bug.
ANSWER 2
Score 4
You can try some clipboard manager applications such as Ditto, here is the link Ditto
ANSWER 3
Score 4
You can not stop this, but there is a workaround
In Windows 10 (and I assume in Windows 11 too) you can press Win + V instead of Ctrl + V. This brings up a popup with the 25 most recent items on the clipboard. You can navigate scrolling or up and down arrows, and you can pick an item to insert with Enter, or a mouse click.
It can be inconvenient to use something else in Excel, but might be simpler than instaling a clipboard manager application.