Struggling to copy and paste data from one cell to another, or from one PC to another PC, every time getting the popup message Microsoft Excel Cannot Paste the Data error… then RELAX!. In this article check out the complete information about the Excel cannot copy paste data error and as well how to fix it.
Microsoft Excel is a highly popular application of Microsoft Office suite because this appears on the top requirements for job application.
In the professional or working life, this is very popular and you don’t keep away yourself from using this complex application.
Using MS Excel make the work dramatically easy, this helps the user to carry out complex calculations easily, create budgets, produce graphs & charts, sort and store data and many others.
Well apart from its uses and making the work easy this is highly prone to corruption and easily gets corrupted.
Excel is having many complicated functions and features familiar with unlike the other MS Office programs like Word or PowerPoint.
And this is the reason using Excel seems scary to some users.
However, if you are well-known with Excel, then this doesn’t mean that you won’t face any corruption or errors in your journey.
There are many types of errors, corruption and issues appear to the users time to time.
Well, this is highly frustrating as a small error can corrupt your Excel workbook and as a result, you are unable to open your Excel file.
In this article, I am going to describe common Excel cannot paste Error.
Overview of Excel File Cannot Paste the Data Error
While working on Excel file have you ever encountered suddenly an annoying rectangle popup and you closed the prompt and try to click Ctrl+ C and Ctrl +V (copy and paste) again and the popup message appears again and again…
Well, this happens in many cases when you try to copy and paste data from one spreadsheet to another.
In some cases, this Excel file cannot paste error is fixed easily like if you have merged cell, then this is causing the issue.
This error is no0t limited to any particular excel versions it is found that Excel 2007, 2010, 2013 and 2016 users are struggling with the error.
Why I am Getting Microsoft Excel Cannot Paste The Data Error
The common reason behind this is if you try to copy data from a merged cell range and paste into non-merged cells.
And if you are not familiar with the practice of multiple copy pasting data then, in this case, you start getting the Microsoft Excel Cannot Paste data error.
How to Fix Microsoft Excel Cannot Paste Data Error
Solution 1: Restart the Excel File
In many cases simply restarting the Excel file solves the issues and errors.
So before trying the below-given solution save the Excel workbook > close Excel and the Open the Excel file.
Now check if you are able to copy and paste data without error.
Solution 2: Check the Merge Cell
Very firstly, check does your data have merged cells? As the main reason behind getting the error is it is not possible to paste data from a merged cell range into a non-merged cells range.
So, to fix the error, choose the data > click on Merge and Center to toggle it off > try the copy the data again.
Or selecting the data > choose to unmerge cells > and then copy > now you are able to paste data into other cells.
Solution 3: Disable Macro Express Application
Well, this is a working solution that helps the users to resolve Excel Cannot Paste the Data error.
Macro Express is a Windows-based application, this permits the users to record, edit and play back mouse and keyboard macros.
And running the Macros Express program in the background causes the errors.
So simply check for the background running programs in your Windows OS and disable the Macro Express.
Doing this will help you to troubleshoot cannot paste error in Excel.
You May Also Read:
- Solved: MS Excel Cannot be Opened or Repaired
- How To Fix ‘Cannot Copy .Xls’ Error Message
- How To Resolve ‘Excel Cannot Open The File ‘(Filename)’.Xlsx’ Error
Solution 4: Restart the PC in Clean Boot State
If none of the above-given solutions helps you to fix Excel cannot paste the data error, then this means your Excel file is dealing with any kind of corruption.
So here it is recommended to try restarting the system in the clean-boot state and check whether the error is fixed or not.
Follow the complete steps to clean boot your Windows PC: How to perform a clean boot in Windows
Solution 5: Make Use Of the Automatic Repair Utility
Make use of the professional recommended MS Excel Repair Tool to repair corrupt, damaged as well as errors in Excel file. This tool allows to easily restore all corrupt excel file including the charts, worksheet properties cell comments, and other important data. With the help of this, you can fix all sort of issues, corruption, errors in Excel workbooks. This is a unique tool to repair multiple excel files at one repair cycle and recovers the entire data in a preferred location. It is easy to use and compatible with both Windows as well as Mac operating system. This supports the entire Excel versions and the demo version is free.
Steps to Utilize MS Excel Repair Tool:
Well, I have done my job now it’s your turn to follow the given fixes and check which solution works for you to fix Microsoft Excel cannot paste the data error.
Facing these types of error is common in Excel, but the good news is that it can be fixed by following certain fixes.
Additionally, Excel is an essential application and used in daily life, so it is recommended to handle the Excel file properly and follow best preventive steps to protect your Excel files from getting corrupted.
Despite it, always create a valid backup of your crucial Excel data and as well scan your system with good antivirus program for virus and malware infection.
If, in case you have any additional questions concerning the ones presented, do tell us in the comments section below or you can also visit our Repair MS Excel Ask Question