A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This issue is reported after update KB5002914 for Excel 2016. A documented resolution from the related support discussion is to uninstall KB5002914 and restart Windows. If copy/paste still does not work after removing that update, reinstall Office.
Because the problem also affects fill behavior for numeric values and formulas, test in this order:
- Uninstall KB5002914
- Open Settings or Control Panel for installed updates.
- Remove KB5002914.
- Restart the PC.
- Test Excel again
- Try Ctrl+C / Ctrl+V in a new blank workbook.
- Try dragging or filling numeric and formula cells.
- If the issue remains, reinstall Office
- The accepted resolution in the related case states that some systems required an Office reinstall to restore copy/paste functionality.
- If Paste Special is available, use it as a temporary workaround
- In similar cases, Paste Special > Values or Paste Special > Formulas and Number Formats continued to work while normal paste failed.
If Paste Special is also missing or unreliable, verify this Excel setting:
- Go to File > Options > Advanced.
- Under Cut, copy and paste, make sure Show Paste Options button when content is pasted is checked.
If needed, also test Excel in Safe Mode to rule out add-in conflicts:
- Hold CTRL while starting Excel, then confirm Safe Mode.
- If paste works there, disable add-ins one at a time and leave the conflicting add-in disabled.