Excel Copy and Paste Not Working? Here's How to Fix It in 7 Ways

Why Is Copy and Paste Not Working in Excel?

Several issues can cause copy and paste to stop working in Excel. The cause may be specific to Excel, the current workbook, or a recent Office update.

• KB5002914 update issue: Microsoft has confirmed a known issue affecting Excel 2024, 2021, 2019, and 2016.
• Clipboard problems: Excel or the Windows clipboard may not handle copied content correctly.
• Excel add-ins: An add-in can interfere with Excel functions, including copy and paste.
• Merged cells or incompatible ranges: Differences between the copied range and destination can prevent Excel from pasting data as expected.
• Workbook-specific problems: If copy and paste works in other workbooks, the current file may be causing the problem.
• Office problems: Damaged Office files or other Excel issues can also affect basic functions.

If you are experiencing Excel copy and paste not working on Windows 10/11 after a recent update, check KB5002914 before trying more general fixes.

How to Fix Excel Copy and Paste Not Working

1 Roll Back KB5002914 If It Caused the Problem

If Excel copy and paste stopped working after an update, check whether KB5002914 was recently installed. Microsoft has confirmed that it can cause Paste to fail silently, with the copied cells remaining selected and the destination unchanged.

The rollback method depends on your Office installation. Office 2016 can use MSI or Click-to-Run, while Office 2019, 2021, 2024, and Microsoft 365 use Click-to-Run.

To check your Office installation type, open Excel and go to "File > Account > About Excel". Click-to-Run installations show a Version and Build number and include "Click-to-Run". MSI installations do not show a Version and Build number there.

For MSI-Based Office

If you have an MSI-based installation, you can try uninstalling KB5002914:

• Press Windows + R, type appwiz.cpl, and press Enter.

• Select "View installed updates" and find "KB5002914".

  

• Select "Uninstall", restart your computer, and test copy and paste in Excel.

For Click-to-Run Office

Click-to-Run installations do not normally remove KB5002914 through the installed updates list. Instead, roll back Office to an earlier build using the Office Deployment Tool (ODT).

The target build depends on your Office version and update channel. For managed or work devices, contact your IT administrator before rolling back Office.

• Open Excel and go to "File > Account > About Excel" to check your current build and update channel.

  

• Download and extract Microsoft's Office Deployment Tool (ODT), then create a "configuration.xml" file, then enter the earlier matching build as the Target Version.

  

• Open Command Prompt as an administrator, navigate to the ODT folder, and run setup.exe /configure configuration.xml.

• Wait for Office to finish rolling back, restart Excel, and test copy and paste again.

Make sure the target build matches your Office update channel. If rolling back does not fix the problem, continue with the next method.

2 Restart Excel and Check the Clipboard

A temporary Excel or clipboard problem can make copy and paste stop responding in Excel.

Start by completely closing Excel and opening it again. If you have multiple Excel windows or workbooks open, close them before restarting the application.

Then test the Windows clipboard outside Excel. For example, copy a short piece of text from another application and paste it somewhere else. If copy and paste works normally in other programs but not in Excel, the problem is more likely related to Excel.

3 Start Excel in Safe Mode and Disable Add-ins

Excel add-ins can sometimes interfere with normal application functions. Safe Mode lets you test Excel without loading certain customizations and add-ins.

On Windows 11 or Windows 10:

• Press Windows + R to open the Run dialog.

• Type excel /safe.

  

• Press Enter.

• Test copy and paste in Excel.

Microsoft recommends Safe Mode to check whether an add-in or extension is causing an Office problem.

If copy and paste works in Safe Mode, disable your Excel or COM add-ins and restart Excel normally. Go to "File > Options > Add-ins", select "COM Add-ins", and choose "Go". Enable the add-ins one at a time to identify the conflict.

4 Check Merged Cells and the Destination Range

Excel may have trouble pasting data when the source and destination areas have different structures.

Check whether the destination contains merged cells. You should also make sure the selected destination range matches the data you are copying.

For example, try copying one cell to another single cell first. If that works, test a larger range. You can also temporarily unmerge cells to see whether the merged layout is causing the problem.

This step is especially useful when copy and paste works in some areas of a workbook but fails in a specific range.

5 Test Copy and Paste in a New Workbook

A quick way to determine whether the problem comes from Excel or a specific workbook is to test a new file.

Open Excel and create a blank workbook. Enter a few values in separate cells, then try copying and pasting them.

• Copy and paste also fails in the new workbook:" The problem may affect Excel itself, an add-in, the clipboard, or a recent update.
• Copy and paste works in the new workbook: The original workbook may contain an issue with its layout, cells, formulas, or other content.

This test can save time because it helps narrow down the source before you change Excel settings or repair Office.

6 Try Different Ways to Copy and Paste

If keyboard shortcuts are not working, try another way to perform the same operation.

You can test:

• Ctrl+C and Ctrl+V
• Right-click "Copy" and "Paste"
• The "Copy" and "Paste" buttons on the Excel ribbon
• "Paste Special" and options such as "Values" or "Formulas"

For example, if Excel Ctrl C and Ctrl V not working but Paste Special still works, the problem may be limited to the standard paste operation rather than the copied data itself.

Some users affected by the recent KB5002914 issue have also reported temporary workarounds such as using Ctrl+X, then Ctrl+Z, followed by Ctrl+V. These are user-reported workarounds rather than an official Microsoft fix, so results may vary.

7 Repair Microsoft Office

If the problem continues and does not appear to be related to KB5002914, repair your Office installation.

On Windows 11:

• Press Windows + I to open Settings.

• Select "Apps" and search for your Microsoft 365 or Office installation.

• Click the three-dot menu next to it and select "Modify".

• Choose "Quick Repair" or "Online Repair".

  

• Once the repair finishes, restart your computer.

• Open Excel and test copy and paste again.

How to Recover Lost or Missing Excel Files with 4DDiG

In some cases, troubleshooting Excel issues, such as Excel not responding or copy and paste not working, can result in a missing or accidentally deleted file. Before trying recovery software, check available backups and locations such as the "Recycle Bin, OneDrive, SharePoint, or File History".

If you cannot find the Excel file in your backups, 4DDiG Data Recovery can scan your Windows drive and connected storage devices, including HDDs, SSDs, USB drives, and SD cards.

It supports Excel files along with other common documents, such as Word, PowerPoint, and PDF files. Follow these steps to find and recover your missing Excel files:

• Download and install 4DDiG. Open it and select the drive where the missing Excel file was stored.

  

• 4DDiG will scan the selected drive automatically. On the left panel, you can switch to the "Type" tab to find Excel and other document files.

  

• During or after the scan, select the missing Excel files and click "Preview". Once you find the files you need, click "Recover".

  

• When prompted, save the recovered files to a different drive to avoid overwriting the lost data.

  
  

Conclusion

When Excel copy and paste is not working, check recent Windows updates first, especially KB5002914. If the issue persists, work through the Excel and Office troubleshooting steps to identify the cause.

If troubleshooting results in a missing or accidentally deleted Excel file and no usable backup is available, 4DDiG Data Recovery can scan your storage for recoverable files and let you preview them before recovery.