Fix Excel Cannot Paste Copied Data Without Clearing the Clipboard
Question details
The user is unable to paste data copied from external applications into Excel without manually clearing the previously copied item from the clipboard first.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Copying data from another program and attempting to paste it into an Excel spreadsheet.
- Observed behavior
- Excel refuses to paste the newly copied data, remaining stuck on the previous clipboard item until the user manually clears the clipboard history.
Ensure your Windows operating system and Microsoft Office suite are updated to the latest versions, and temporarily pause any third-party clipboard manager applications.
Adjust Windows and Office Clipboard Settings
Modifying how Excel interacts with the Windows clipboard can resolve conflicts preventing new data from being pasted.
The Windows Clipboard and the Office Clipboard have distinct limits and configurable settings. Conflict between the two is the most common cause of paste failures in Excel.
Press the Windows key + V to open the system Clipboard History. Click 'Clear all' to remove any stuck data.
Open Excel, navigate to the 'Home' tab, and click the small dialog box launcher (arrow icon) in the bottom-right corner of the 'Clipboard' group.
Click 'Options' at the bottom of the Clipboard task pane. Uncheck 'Show Office Clipboard Automatically' and 'Collect Without Showing Office Clipboard'.
Close Microsoft Excel entirely and reopen your spreadsheet. Attempt to copy data from another application and paste it into a cell.

Test Excel in Safe Mode to Identify Add-in Conflicts
If adjusting clipboard settings does not work, a third-party Excel add-in might be intercepting your copy-paste actions.
Try WPS Office to Seamlessly Copy and Paste Data
If Microsoft Excel continues to experience stubborn clipboard errors, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with seamless clipboard management for smooth data import and export.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx files.
- 3. Copy and Paste Smoothly: Copy data from any external application and paste it directly into WPS Spreadsheet without clipboard errors.

Frequently Asked Questions
Why does Excel say the clipboard cannot be emptied?
This error occurs when another background application (like a download manager, remote desktop tool, or screen capture software) is actively monitoring or holding onto the Windows clipboard, preventing Excel from accessing it.
How do I clear the Office Clipboard manually?
Open Excel, go to the Home tab, and click the small expand arrow in the bottom right corner of the Clipboard section. In the pane that appears on the left, click the 'Clear All' button.
Why does copying and pasting work normally on my other computer?
Clipboard issues are often localized to a specific machine. It usually indicates a conflict with software installed on that specific computer, corrupted Office cache, or different Windows clipboard configurations between the two devices.
Can web browser extensions interfere with Excel's clipboard?
Yes. Certain browser add-ons, particularly security extensions or password managers, actively monitor clipboard contents and can inadvertently lock the system clipboard, disrupting standard operations in Microsoft Office.




