{"id":3452,"date":"2024-10-25T09:49:56","date_gmt":"2024-10-25T09:49:56","guid":{"rendered":"https:\/\/www.tinyfrom.com\/file-solutions\/?p=3452"},"modified":"2024-12-11T08:45:59","modified_gmt":"2024-12-11T08:45:59","slug":"microsoft-excel-cannot-paste-the-data","status":"publish","type":"post","link":"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/","title":{"rendered":"How to Fix Microsoft Excel Cannot Paste the Data Error?"},"content":{"rendered":"\n<p><em>\u201cI\u2019ve been trying to copy and paste some Excel data to a new workbook, but it\u2019s showing <\/em><strong><em>Microsoft Excel cannot paste the data<\/em><\/strong><em>. Please, how can I achieve this?\u201d<\/em><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"329\" height=\"160\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-cannot-paste-the-data.png\" alt=\"excel cannot paste the data\" class=\"wp-image-3457\" style=\"width:450px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-cannot-paste-the-data.png 329w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-cannot-paste-the-data-300x146.png 300w\" sizes=\"auto, (max-width: 329px) 100vw, 329px\" \/><\/figure><\/div>\n\n\n<p>The Microsoft Excel cannot paste the data error is a common issue that occurs when trying to copy and paste data from one workbook to another. It signifies that the data you\u2019re trying to paste is not the same as the cell format (like Date, Symbols, Text, Time, Currency, etc.) used in the column. Other times, it could be that the workbook settings are different or you&#8217;ve exceeded Microsoft Excel specifications.<\/p>\n\n\n\n<p>Finding a way around this issue can be exhausting. But don\u2019t worry. In this article, we will discuss the common reasons why \u201cMicrosoft Excel cannot paste the data\u201d error pops up and the possible methods to solve them.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_73 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Why_Microsoft_Excel_Cannot_Paste_the_Data\" title=\"Why Microsoft Excel Cannot Paste the Data?\">Why Microsoft Excel Cannot Paste the Data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#8_Possible_Methods_to_Fix_Microsoft_Excel_Cannot_Paste_the_Data_Error\" title=\"8 Possible Methods to Fix Microsoft Excel Cannot Paste the Data Error\">8 Possible Methods to Fix Microsoft Excel Cannot Paste the Data Error<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Create_a_Workbook_Copy_to_Fix_%E2%80%9CCannot_Paste_in_Excel%E2%80%9D_Error\" title=\"Create a Workbook Copy to Fix \u201cCannot Paste in Excel\u201d Error\">Create a Workbook Copy to Fix \u201cCannot Paste in Excel\u201d Error<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Check_and_Fix_the_Wrong_Cell_Format\" title=\"Check and Fix the Wrong Cell Format\">Check and Fix the Wrong Cell Format<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Disable_the_Macro_Express_Application\" title=\"Disable the Macro Express Application\">Disable the Macro Express Application<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Check_the_Size_of_the_Copy_and_Paste_Area\" title=\"Check the Size of the Copy and Paste Area\">Check the Size of the Copy and Paste Area<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Use_the_Paste_Special_Option_to_Fix_%E2%80%9CExcel_is_Unable_to_Paste_in_Cell%E2%80%9D\" title=\"Use the Paste Special Option to Fix \u201cExcel is Unable to Paste in Cell\u201d\">Use the Paste Special Option to Fix \u201cExcel is Unable to Paste in Cell\u201d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Check_for_the_Merged_Cells_to_Fix_%E2%80%9CCannot_Paste_in_Excel%E2%80%9D\" title=\"Check for the Merged Cells to Fix \u201cCannot Paste in Excel\u201d\">Check for the Merged Cells to Fix \u201cCannot Paste in Excel\u201d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Run_Microsofts_Automatic_Repair_Feature_to_Fix_%E2%80%9CExcel_Cannot_Paste_Data%E2%80%9D\" title=\"Run Microsoft\u2019s Automatic Repair Feature to Fix \u201cExcel Cannot Paste Data\u201d\">Run Microsoft\u2019s Automatic Repair Feature to Fix \u201cExcel Cannot Paste Data\u201d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Repair_Corrupted_Excel_Files_to_Fix_%E2%80%9CExcel_Cannot_Paste_the_Data_Error%E2%80%9D\" title=\"Repair Corrupted Excel Files to Fix \u201cExcel Cannot Paste the Data Error\u201d\">Repair Corrupted Excel Files to Fix \u201cExcel Cannot Paste the Data Error\u201d<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.tinyfrom.com\/file-solutions\/microsoft-excel-cannot-paste-the-data\/#FAQs_on_Fixing_Excel_Cannot_Paste_the_Data_Error\" title=\"FAQs on Fixing Excel Cannot Paste the Data Error\">FAQs on Fixing Excel Cannot Paste the Data Error<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Microsoft_Excel_Cannot_Paste_the_Data\"><\/span>Why Microsoft Excel Cannot Paste the Data?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>These are the popular reasons why Excel cannot paste the data into a new workbook:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ud83d\udcddToo Many Cells Styles:<\/strong> The limit for unique cell styles in Microsoft Excel is 65,490 per workbook. If this limit is exceeded, Excel won\u2019t be able to paste the data you copied.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ud83d\udeabData Size Limitation:<\/strong> When <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3\" target=\"_blank\" rel=\"noopener nofollow\" title=\"\">Microsoft Excel specifications on row, column, and data size<\/a> are exceeded, it won\u2019t be able to paste the data you copied.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u26a0\ufe0fFormatting Issues:<\/strong> Complex formatting, such as merging cells or locked cells, can prevent pasting if the destination workbook doesn\u2019t have the same format as the source.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u274eData Type Mismatch:<\/strong> Pasting data that doesn\u2019t match the destination cell\u2019s format, such as pasting text into a number filed, can cause errors.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_Possible_Methods_to_Fix_Microsoft_Excel_Cannot_Paste_the_Data_Error\"><\/span>8 Possible Methods to Fix Microsoft Excel Cannot Paste the Data Error<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Explained below are the reliable methods that can help you get rid of the \u201cExcel cannot paste data\u201d error.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Create_a_Workbook_Copy_to_Fix_%E2%80%9CCannot_Paste_in_Excel%E2%80%9D_Error\"><\/span>Create a Workbook Copy to Fix \u201cCannot Paste in Excel\u201d Error<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This method is most suitable when you have too many cell styles and Excel cannot paste the data you copied. You can create a new workbook and paste the data without experiencing any error or making changes to your data.<\/p>\n\n\n\n<p>\ud83d\udc49Here are the steps to follow:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the former workbook i.e., the workbook where your data is saved. Let\u2019s call it <strong>Workbook A<\/strong>.<\/li>\n\n\n\n<li>Go to <strong>File<\/strong>, click <strong>New<\/strong>, and choose <strong>Blank Workbook<\/strong>. Let\u2019s call it <strong>Workbook B<\/strong>.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"450\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-workbook.png\" alt=\"excel workbook\" class=\"wp-image-3458\" style=\"width:500px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-workbook.png 616w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-workbook-300x219.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>In Workbook A, navigate to the bottom, and right-click the tab you want to copy. To select multiple tabs, press down <strong>Ctrl<\/strong> and tap on the tabs.<\/li>\n\n\n\n<li>In the right-click dropdown menu, select <strong>Move<\/strong> <strong>or<\/strong> <strong>Copy<\/strong>. Then, choose Workbook B as the destination.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"358\" height=\"308\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-move-or-copy.png\" alt=\"excel move or copy button\" class=\"wp-image-3459\" style=\"width:400px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-move-or-copy.png 358w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-move-or-copy-300x258.png 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Ensure the <strong>Create a Copy<\/strong> box is ticked. Click <strong>OK<\/strong>.<\/li>\n\n\n\n<li>Now, your data will be in Workbook B without any cell style issue or can\u2019t paste in Excel error.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Check_and_Fix_the_Wrong_Cell_Format\"><\/span>Check and Fix the Wrong Cell Format<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If the cell data you copied doesn\u2019t match the column title of where you want to paste, there will be an error. Thus, check whether the cell formats of the column of the source spreadsheet (where you\u2019re copying the data) match the destination spreadsheet (where you want to paste the data). If they don\u2019t match, change the cell format.<\/p>\n\n\n\n<p>\ud83d\udc49Here are the steps to fix the Excel cannot paste data error via this method:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the destination spreadsheet and click on the column heading of the cells you want to paste the data.<\/li>\n\n\n\n<li>Select the <strong>Home<\/strong> tab and click the <strong>General<\/strong> drop-down menu.<\/li>\n\n\n\n<li>Choose the format that matches the data you want to paste in the cell whether Number, Currency, Accounting, Short Date, Long Date, Time, etc.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"585\" height=\"524\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/check-the-cell-format.jpg\" alt=\"check the cell format\" class=\"wp-image-3461\" style=\"width:450px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/check-the-cell-format.jpg 585w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/check-the-cell-format-300x269.jpg 300w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Disable_the_Macro_Express_Application\"><\/span>Disable the Macro Express Application<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you\u2019re a Windows user, you might be experiencing Excel unable to paste in a cell error because of the Macro Express App. It\u2019s an application on Windows computers that runs in the background, allowing users to record, playback, and modify mouse\/keyboard macros.<\/p>\n\n\n\n<p>While the app has its advantages, it can cause Microsoft Excel not to paste data. So, ensure you check the applications running in the background and disable the Macro Express App before copying data from a spreadsheet.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"792\" height=\"512\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/macro-express-application.jpg\" alt=\"macro express application\" class=\"wp-image-3463\" style=\"width:600px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/macro-express-application.jpg 792w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/macro-express-application-300x194.jpg 300w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/macro-express-application-768x496.jpg 768w\" sizes=\"auto, (max-width: 792px) 100vw, 792px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Check_the_Size_of_the_Copy_and_Paste_Area\"><\/span>Check the Size of the Copy and Paste Area<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you copy data from 200 rows and columns but want to paste it in an area of 150 rows and columns, you can\u2019t paste here because the copy area doesn\u2019t match.<\/p>\n\n\n\n<p>\ud83d\udc49To fix this, it\u2019s either select 200 rows and columns as it is in the source workbook or follow this process:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the upper-left cell.<\/li>\n\n\n\n<li>Select the <strong>Home<\/strong> tab, tap the dropdown icon under <strong>Paste<\/strong>, and click <strong>Paste Special<\/strong>.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"447\" height=\"685\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/paste-special-button.png\" alt=\"excel paste special button\" class=\"wp-image-3464\" style=\"width:400px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/paste-special-button.png 447w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/paste-special-button-196x300.png 196w\" sizes=\"auto, (max-width: 447px) 100vw, 447px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Choose your preferred options (whether paste all, formulas, skip blanks, formats, values, etc.) to control how the data is pasted.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"456\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/choose-preferred-options.jpg\" alt=\"choose preferred options\" class=\"wp-image-3466\" style=\"width:400px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/choose-preferred-options.jpg 412w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/choose-preferred-options-271x300.jpg 271w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Use_the_Paste_Special_Option_to_Fix_%E2%80%9CExcel_is_Unable_to_Paste_in_Cell%E2%80%9D\"><\/span>Use the Paste Special Option to Fix \u201cExcel is Unable to Paste in Cell\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pasting special graphics from one spreadsheet to another can result in \u201cMicrosoft Excel cannot paste this data\u201d error. Special graphics cannot be moved using the traditional Paste function. Thankfully, there\u2019s a dedicated Paste Special function that has various options for pasting data.<\/p>\n\n\n\n<p>\ud83d\udc49Here\u2019s how to paste data into Excel using the Paste Special function:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Copy the data from the source spreadsheet.<\/li>\n\n\n\n<li>Open the destination spreadsheet and right-click on any cell. Select <strong>Paste Special<\/strong> and choose the best option that matches the data.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"398\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/select-paste-special.png\" alt=\"select paste special\" class=\"wp-image-3468\" style=\"width:400px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/select-paste-special.png 414w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/select-paste-special-300x288.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Check_for_the_Merged_Cells_to_Fix_%E2%80%9CCannot_Paste_in_Excel%E2%80%9D\"><\/span>Check for the Merged Cells to Fix \u201cCannot Paste in Excel\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pasting data into merged cells or from merged cells can cause \u201cExcel cannot paste the data\u201d error. Therefore, before copying the data, unmerge all the cells.<\/p>\n\n\n\n<p>\ud83d\udc49To do so, follow this procedure:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the source spreadsheet and highlight all the data you want to copy.<\/li>\n\n\n\n<li>Select the <strong>Home<\/strong> tab and click <strong>Merge and Center<\/strong>. From the drop-down menu, choose <strong>Unmerge Cells<\/strong>.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"424\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/unmerge-cells.jpg\" alt=\"unmerge cells\" class=\"wp-image-3470\" style=\"width:550px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/unmerge-cells.jpg 724w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/unmerge-cells-300x176.jpg 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>After the cells are unmerged, you will be able to copy and paste the data without experiencing any error.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Run_Microsofts_Automatic_Repair_Feature_to_Fix_%E2%80%9CExcel_Cannot_Paste_Data%E2%80%9D\"><\/span>Run Microsoft\u2019s Automatic Repair Feature to Fix \u201cExcel Cannot Paste Data\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Another reason why Microsoft Excel cannot paste the data is because the spreadsheet is damaged. When Excel opens the spreadsheet, it immediately goes into a File Recovery Mode, where it tries to repair the file.<\/p>\n\n\n\n<p>But this only happens if the File Recovery Mode is activated. If it isn\u2019t activated, here\u2019s how to manually fix Excel is unable to paste in a cell:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On the source spreadsheet, click the <strong>File<\/strong> tab, and choose <strong>Open<\/strong>.<\/li>\n\n\n\n<li>Right-click on the damaged spreadsheet and select <strong>Copy to Clipboard<\/strong>.<\/li>\n\n\n\n<li>Select the damaged spreadsheet, scroll down to click the arrow beside Open, and choose <strong>Open and Repair<\/strong>. This will fix the Excel file and help you get back as much data as possible.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"670\" height=\"457\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-open-and-repair-feature.jpg\" alt=\"excel open and repair feature\" class=\"wp-image-3472\" style=\"width:550px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-open-and-repair-feature.jpg 670w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/excel-open-and-repair-feature-300x205.jpg 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Repair_Corrupted_Excel_Files_to_Fix_%E2%80%9CExcel_Cannot_Paste_the_Data_Error%E2%80%9D\"><\/span>Repair Corrupted Excel Files to Fix \u201cExcel Cannot Paste the Data Error\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If all the methods above didn\u2019t work, it may be that the file itself has some problems, meaning that you have to repair the damages. The most reliable option to do this is <a href=\"https:\/\/www.tinyfrom.com\/corrupted-file-recovery-online\/\" target=\"_blank\" rel=\"noopener\" title=\"\">ONERECOVERY Online File Repair<\/a>. It is a professional tool that fixes all kinds of Excel file problems, such as inaccessible files, unreadable files, or files showing gibberish content. This tool harnesses the power of advanced AI technology to identify the defects within your spreadsheet and repair them using the most suitable solution.<\/p>\n\n\n\n<p>ONERECOVERY Online File Repair is efficient in fixing various Excel file formats, including XLSX and XLS. It can even <a href=\"https:\/\/www.tinyfrom.com\/file-solutions\/repair-docx-files\/\" target=\"_blank\" rel=\"noopener\" title=\"\">repair corrupted DOCX files<\/a>.<\/p>\n\n\n\n<p>Above all, it has a user-friendly interface that enables individuals with varying technical backgrounds (beginners or experts) to repair files easily.<\/p>\n\n\n\n<p>\ud83d\udc49Here\u2019s how to fix Microsoft Excel cannot paste the data using ONERECOVERY Online File Repair:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the official <a href=\"https:\/\/www.tinyfrom.com\/corrupted-file-recovery-online\/\" target=\"_blank\" rel=\"noopener\" title=\"\">ONERECOVERY Online File Repair<\/a> website and click <strong>Upload File<\/strong> to choose the corrupted Excel files you want to fix.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"945\" height=\"529\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/upload-file-1.jpg\" alt=\"file repair onerecovery\" class=\"wp-image-3372\" style=\"width:650px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/upload-file-1.jpg 945w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/upload-file-1-300x168.jpg 300w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/upload-file-1-768x430.jpg 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Immediately, the files begin to undergo a thorough scan to identify and repair any defect.<\/li>\n\n\n\n<li>Once the repair is finished, click <strong>Download<\/strong> to save the files on your device.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"395\" src=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/download-repaired-files-from-onerecovery.png\" alt=\"download repaired files from onerecovery\" class=\"wp-image-3153\" style=\"width:650px\" srcset=\"https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/download-repaired-files-from-onerecovery.png 700w, https:\/\/www.tinyfrom.com\/file-solutions\/wp-content\/uploads\/download-repaired-files-from-onerecovery-300x169.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can trust the methods discussed above to resolve the \u201cMicrosoft Excel cannot paste the data\u201d error on your PC. The ONERECOVERY Online File Repair tool, on the other hand, is the best option if your Excel file is corrupted. It will help you retrieve your data if you face any file corruption.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"FAQs_on_Fixing_Excel_Cannot_Paste_the_Data_Error\"><\/span>FAQs on Fixing Excel Cannot Paste the Data Error<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Continue reading to get more knowledge about how to paste data into Excel without experiencing any issue.<\/p>\n\n\n\n<p><strong>1\ufe0f\u20e3Why Can I Not Paste from One Excel Spreadsheet to Another?<\/strong><\/p>\n\n\n\n<p>Here are a couple of reasons why you cannot paste from one Excel spreadsheet to another:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cell format restrictions<\/li>\n\n\n\n<li>Different data types<\/li>\n\n\n\n<li>Too many cell styles<\/li>\n\n\n\n<li>The file size is too large<\/li>\n\n\n\n<li>Macros interference<\/li>\n\n\n\n<li>Invalid range<\/li>\n\n\n\n<li>Data size limitations<\/li>\n\n\n\n<li>Spreadsheet protection settings<\/li>\n\n\n\n<li>Overloaded clipboard<\/li>\n\n\n\n<li>The Excel file is corrupted<\/li>\n<\/ul>\n\n\n\n<p>2\ufe0f\u20e3<strong>How Do I Copy and Paste in Excel without Changing the Format?<\/strong><\/p>\n\n\n\n<p>Follow this process to copy and paste in Excel without changing the format:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the source workbook and copy the data to the Clipboard by pressing <strong>Ctrl<\/strong> + <strong>C<\/strong>.<\/li>\n\n\n\n<li>Go to the destination workbook and click the cell you want to paste the data.<\/li>\n\n\n\n<li>Select the <strong>Home<\/strong> tab, click the arrow under Paste, and select the <strong>Paste Special<\/strong> option.<\/li>\n\n\n\n<li>Choose the best format that matches the copied data.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u201cI\u2019ve been trying to copy and paste some Excel data to a new workbook, but&hellip;<\/p>\n","protected":false},"author":3,"featured_media":3457,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-3452","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-repair-files"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/posts\/3452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/comments?post=3452"}],"version-history":[{"count":9,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/posts\/3452\/revisions"}],"predecessor-version":[{"id":3666,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/posts\/3452\/revisions\/3666"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/media\/3457"}],"wp:attachment":[{"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/media?parent=3452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/categories?post=3452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tinyfrom.com\/file-solutions\/wp-json\/wp\/v2\/tags?post=3452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}