Fixed: Microsoft Excel Cannot Paste the Data

Excel failed to paste data? Effective way to resolve "Microsoft Excel cannot paste data" error

Microsoft Excel is a widely used spreadsheet editor developed by Microsoft, suitable for Windows, macOS, Android and iOS systems. It plays an important role in data visualization, data organization and rapid numerical calculations. However, sometimes Excel also encounters some errors, such as "Excel opens with a very small window", "Excel closes without warning", etc. Today we will discuss another Excel issue: "Microsoft Excel cannot paste data".

This problem is usually related to cell format mismatch, cell merging, software conflicts, etc. When you encounter this error, you can try restarting Microsoft Excel to see if the problem is resolved. If you still can't copy and paste in Excel, you can try the following workaround.

How to fix Microsoft Excel fails to paste data error

Method 1: Change the cell format

If the information you are trying to paste does not match the format of the cells in the column, you may encounter the "Microsoft Excel cannot paste data" error. To exclude this reason, you need to change the cell format.

First, click on the column title (A, B, C, etc.) of the column you want to change.

Second, under the Start tab, expand the Number Format box menu, and select the cell format that matches the information you are trying to paste into the column.

Method 2: Avoid copying and pasting data from merged cells

Copying and pasting data directly between merged cells and normal cells may cause mismatch between source and target cells, resulting in pasting failure. In this case, you need to unmerge the cells and then copy and paste the data.

Select the merged cell and click the "Merge After" button under the Start tab.

Method 3: Disable Macro Express Application

Macro Express is a powerful Windows automation tool that allows you to record, edit, and playback mouse and keyboard macros. Depending on the user experience, it can be the cause of the failure of the paste function. To resolve this issue, you can consider temporarily disabling or uninstalling the software and checking if the error disappears.

Method 4: Clean start the computer

Clean boot starts Windows with minimal drivers and startup programs. By performing a clean boot, you can determine if the background program is interfering with Excel. This is a viable way to diagnose the problem of "Microsoft Excel cannot paste data".

You can find detailed instructions in this article: How to cleanly boot Windows 10 and why?

Method 5: Start Excel in Safe Mode

Starting Excel in safe mode is also an effective way to solve the problem of failure of copy and paste function. This can effectively determine if the problem is caused by an add-in or an extension.

First, close all open Excel spreadsheets.

Secondly, press the Windows R key combination to open the run window. Next, type excel.exe /safe in the text box and press Enter .

If the copy-paste function works properly in safe mode, it means the problem is related to add-ins or extensions and you need to disable them.

Summarize

All in all, if you encounter the "Microsoft Excel cannot paste data" error, you can try the above method. Hope you can successfully resolve this issue.

If you have any questions when using MiniTool Power Data Recovery, please feel free to contact us.

The above is the detailed content of Fixed: Microsoft Excel Cannot Paste the Data. For more information, please follow other related articles on the PHP Chinese website!