Click “Paste Special” and choose a dedicated setting to successfully paste your data.Īnother working solution to fix the “Excel cannot paste data” error is to ignore DDE (Dynamic Data Exchange). Step 2: Now, open the sheet where you want to paste and data and right-click on any cell. ![]() Step 1: First of all, copy the data from the source Excel sheet. Let’s check out how to use “Paste Special” in Microsoft Excel. Fortunately, Microsoft provides a dedicated “Paste Special” option that’ll help you use different types of paste options for special cases. If you’re trying to paste special graphics from one Excel sheet to the other, you won’t be able to do it using the traditional “Paste” option. So, make sure to check the background processes before copying data from an Excel Sheet and close the “Macro Express” application. Unfortunately, the same app can cause errors like “cannot paste the data” in Excel. It’s a Windows-based app that runs in the background and gives users the power to edit, record, and playback mouse/keyboard macros. If you’re working on a Windows machine, the said error can also be triggered by the “Macro Express” application. Solution 3: Disable the Macro Express Application Once the cells are unmerged, you’ll be able to copy the data without any interruption. Step 2: Now, under the “Home” tab, click on “Merge and Center” and choose “Unmerge Cells” from the drop-down menu. Step 1: Open the source Excel sheet and select all the data that you want to copy. To do so, follow the below-mentioned steps. So, before you try copying the data, make sure to unmerge all cells and you won’t face the “cannot paste the data” error anymore. It’s worth noting that you won’t be able to copy data from merged cells and paste it into a regular Excel Sheet. However, before closing the Excel sheet, make sure to press “Ctrl+S” so that you don’t end up losing any valuable data. In many cases, simply restarting the excel sheet will fix the error and you won’t have to perform any advanced solutions. Solution 1: Restart the Excel Fileīefore diving into advanced solutions, let’s first try something simple. Not just any Excel repair tool, but a functional, reliable one that will ensure that all your data will still be in place after the repair, of course. If you find that your Excel file has been corrupted, you would benefit from an Excel repair tool. For instance, you might have a merged cell that causes the issue, or you are simply not familiar with the protocol of multiple copy-pasting, in which your problem will be solved instantly. ![]() Sometimes, you can fix an excel file that cannot paste error with relative ease if the problem is a small one. This error is especially common when you attempt to copy-paste data from one spreadsheet to another. And of course, the prompt shows up again. So you closed the prompt and tried clicking Ctrl+C Ctrl+V again. Have you had those days when you were just normally doing your work and everything is going well until this pesky rectangle suddenly pops up Overview of Excel file cannot paste the data Error Solution 10: Fix Microsoft Excel cannot paste the data Error with Repairit Excel Repair.Solution 9: Use Microsoft’s Automatic Repair Utility to Clean Excel Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |