A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Try these checks in order:
- Make sure both workbooks are open in the same Excel instance. If one workbook is opened in a second Excel window/instance, Excel can fall back to the Windows Paste Special behavior and Excel cell paste options will not work correctly between workbooks.
- Verify that Paste Options is enabled:
- Go to File > Options > Advanced.
- Under Cut, copy and paste, confirm Show Paste Options button when content is pasted is checked.
- Since Safe Mode did not help, check whether Excel events are being cleared by workbook code:
- A
Worksheet_SelectionChangeevent can clear the clipboard and disable Paste Special. - If this workbook contains VBA/event code, set
Application.EnableEventstoFalseand test again.
- A
- Close all web browsers completely and test copy/paste again. Browser conflicts are documented as a cause of Paste Special problems.
- If the problem occurs only when pasting between two Excel windows, open both files in the same Excel instance and retry.
- If this PC is on Excel 2016 version 16.0.4229.1002 preview, there is a known bug where sheet copy/move behaves incorrectly. The documented fix is:
- Uninstall the preview Office build from Control Panel > Program and Features.
- Install a released RTM version of Office.
- Turn on automatic updates.
- If the issue started after a recent Office update and reinstall did not help, an Online Repair of Office is the next documented repair path.
Because copy from Word to Excel works, the problem is likely specific to Excel’s internal copy/paste handling rather than the Windows clipboard itself.
References:
- Paste Special option is missing or not working in Microsoft Office
- You cannot paste any attributes into a workbook in another instance of Excel
- Unable to copy or move sheet in Excel 2016 (16.0.4229.1002)
- After the latest update 1 June 25, I cannot cut and paste anything, even in the same document. Suggestions please. - Microsoft Q&A