Solve the issue with Update Office 2019 Copy & Paste with Excel App

This is a known Excel issue that affected Office 2019 where paste can fail silently after recent updates. The fix is available, but it may not be applied automatically.

1. Update Office to the latest build.
   • In Excel or another Office app, install the latest Office updates.
   • For Office 2019, the issue was fixed in Build 10417.20211.
   • For Excel 2016, the fix is in KB 5002665.
2. Restart Excel after the update and test copy/paste again.
   • Expected result: copied content pastes normally instead of leaving the source selected with no change in the destination cell.
3. If paste still fails, use Paste Special as a workaround.
   • Go to Home > Paste dropdown > Paste Special.
   • Try one of these options:
     • Formula
     • Formula and number formats
     • Values
     • Values and number formats
     • Paste Link
4. If the issue happens in automation or add-ins that copy/paste across multiple Excel instances, avoid running those clipboard operations in parallel.
   • If possible, use APIs that do not interact with the clipboard, such as getting and setting values by array.

Microsoft also notes that installing the latest updates is the required action because the fix might not be applied automatically.

• The paste operation might fail in Excel
• Paste options
• Excel may crash when running multiple instances that use clipboard functionality programmatically