Microsoft Excel Cannot Paste the Data

Sometimes a very common error occurs in your Windows system that states “Microsoft excel cannot paste the data”. The user encounters this message when he tries to copy some data from one file to another. Copy and pasting is a very basic and simple feature but it is very strange that a problem can occur while carrying this task out.

Microsoft excel cannot paste the data error
Error Message

What prevents you to paste the data in excel?

So many Windows users have faced and reported the issue where they are unable to copy and paste the data in Excel Files. There are different reasons that might cause this troublesome of which are listed below:

  • This error might occur if you are trying to copy data from merged cells into non-merged cells.

Pre Tips

If you encounter this error message, try to make sure some basic things are on working properly before you go through any major solution:

  1. Restart your Excel file by closing it and opening it again.
  2. Now make sure that you are not pasting the data from the merged cells into the non-merged cells.
  3. select the data you want to copy.
  4.  Click on Merge and Center to see its components and click on unmerge cells.
  5. Now try to copy and paste your data again.

What to do if you cannot paste the data in Microsoft Excel?

Solution 1: Use Paste Special Option

If you have trouble pasting your data, try to use the Paste special option. To do this, copy the data you want to paste in another worksheet. Now go in the other worksheet, right-click and select Paste Special option to paste your data. This option allows you to paste special graphics into a Microsoft Excel workbook running within a published application or desktop.

Paste Special
Paste Special

Solution 2: Ignore DDE

If you see this error, ignore the Dynamic Data Exchange and try to do the operation again. Follow the steps below to do this.

  1. From the File menu, click Options.
  2. Now click the Advanced tab.
  3. Scroll down to the General Section.
  4. Uncheck the box parallel to Ignore other applications that use Dynamic Data Exchange (DDE).
    Ignoring DDE to fix the microsoft excel cannot paste the data error
    Ignoring DDE

Solution 3: Restart the PC in Clean Boot State

If you still can’t get rid of the Microsoft Excel cannot paste the data 2010 issue, try to restart the PC in clean boot mode and check if the problem is resolved or not. Follow the steps below to carry this task out.

  1. Click the search button in the taskbar. Type “MSConfig” and open it.
    System Configuration
    System Configuration
  2. Click on the Boot tab and uncheck the safe boot.
    Initiating Safe boot to fix the microsoft excel cannot paste the data issue
    Safe boot
  3. Restart and check if the problem is resolved.
  4. After carrying your task out, uncheck the Safe Boot box.

Solution 4: Use Automatic Repair Utility

If you still can’t get rid of this error, try to use third-party software to fix this issue.

  1. Download MS Excel Repair Tool from your favorite browser and install it on our PC.
  2. Select the file you are having trouble with.
  3. Press the Scan button to scan the file.
  4. After the scan is complete, press the Repair button.
  5. Now save the file at your preferred location and check if the error is resolved.

If you need further assistance, click here.

Alan Adams

Alan is a hardcore tech enthusiast that lives and breathes tech. When he is not indulged in playing the latest video games, he helps users with technical problems that they might run into. Alan is a Computer Science Graduate with a Masters in Data Science.
Back to top button