How To Fix Cannot Paste The Data In Microsoft Excel Error


Have you ever come across the "Microsoft Excel Cannot Paste the Data Error" issue? Don"t worry. We have got you covered here! Keep reading lớn find effortless ways khổng lồ fix this issue. When the Excel files get corrupted, you can run the repair tool for file repair to lớn repair the Excel files khổng lồ make Excel work again. Read on to lớn solve your problem & fix the Excel error with the step-by-step guide.

Bạn đang xem: How to fix cannot paste the data in microsoft excel error

About the Author

nhận xét and Awards

When it comes khổng lồ your professional life, you can"t avoid utilizing Microsoft Excel khổng lồ sort your data & do complex calculations in a breeze. But, for some individuals, Excel can be a source of anxiety. In contrast lớn the more user-friendly Word or PowerPoint, Excel has a plethora of complex terminology & functionalities that must be learned.


Microsoft Excel Cannot Paste the Data

Even when you"ve learned how to lớn use the functionalities, the road is still full of bumps. Like any other computer program, the spreadsheet program Excel is susceptible khổng lồ various problems và becomes super aggravating. Throughout this post, we will provide you with an explanation of the Microsoft Excel Cannot Paste the Data Error and instructions on fixing this with reliable solutions.

Workable SolutionsStep-by-step Troubleshooting
Fix 1. Restart ExcelClose the MS Excel program. Restart the Application. Try copying & pasting...Full steps
Fix 2. Check the Merge CellLaunch the source Excel worksheet and make a menu of all the data you would like to copy...Full steps
Fix 3. Disable the Macro ExpressSelect Disable Macro from the context thực đơn when you right-click on the macro...Full steps
Fix 4. Use Paste SpecialMake a copy of the relevant data from the Excel workbook once opened...Full steps
Other SolutionsIgnore DDE > Start Excel in Safe Mode > Restart the PC in Clean Boot State...Full steps

How khổng lồ Fix Microsoft Excel Cannot Paste The Data (10 Fixes)

The Excel issue is quite common when copying and pasting data from one spreadsheet. In some instances, you can be experiencing difficulties because of merged cells or a lack of familiarity with the multiple copy-pasting processes, both of which can be remedied quickly. Here, we"ve highlighted the ten most effective methods which can help you get rid of this problem.

Method 1. Restart Excel khổng lồ Fix Excel Cannot Paste the Data

Before you go into more complicated solutions, why not start with something simple? Most of the time, relaunching the excel sheet will resolve the issue, and no high-level preparations are required. Nonetheless, attempt khổng lồ save your data before closing the Excel program.

Step 1. Close the MS Excel program.

Step 2. Restart the Application.

Step 3. Try copying and pasting the info. Check to see if this works.


Method 2. Check the Merge Cell in Excel to lớn Fix Microsoft Excel Cannot Paste the Data

In an ordinary Excel Sheet, you cannot copy data from merged cells and paste it into another Excel Sheet. Consequently, before you attempt to lớn duplicate the information, unmerge all of the cells by doing the following methods.

Step 1. Launch the source Excel worksheet và make a danh sách of all the data you would lượt thích to copy, then click "copy".

Step 2. To unmerge cells, choose "Merge & Center > Unmerge Cells" from the Home tab on the menu bar.


Method 3. Disable the Macro Express Application

The "Macro Express" software can also cause this problem. It"s a Windows-based program that allows you to lớn make adjustments và record mouse macros. As a result, verify the operating programs in the background before transferring data from Excel. Lớn temporarily deactivate a macro, choose it from the Macro Express Pro - Explorer list & do the following action.

Select Disable Macro from the context menu when you right-click on the macro.


Method 4. Use Paste Special Option to Fix the Error

When utilizing the "Paste" option in Microsoft Excel, the data cannot be pasted due lớn an error.

Step 1. Make a copy of the relevant data from the Excel workbook once opened.

Step 2. Next, xuất hiện the destination sheet & right-click on any cell khổng lồ choose it from the menu. Select the "Paste Special" option from the drop-down menu and select a specialized setting for correctly pasting the data you copied.


Method 5. Ignore DDE to Fix Excel Cannot Paste

Ignoring DDE also adds khổng lồ the resolution of the copy và paste problem. Và here are the steps to follow.

Step 1. Xuất hiện Excel & choose "Options" from the "Files" drop-down menu.

Step 2. Khổng lồ disable the "Ignore other apps that employ Dynamic Data Exchange (DDE)" checkbox in the dialog box, choose the "Advanced" option from the dialog box.

Step 3. You can now go khổng lồ the next step by clicking "OK" lớn store your progressions.


Method 6. Start Excel in Safe Mode

By pressing the CTRL key on your keyboard and the shortcut icon for Excel, you can launch the spreadsheet in Safe mode immediately. The following are the procedures that must be completed to open Excel in Safe Mode using this method.

Also read: How khổng lồ enter Safe Mode?

Step 1.

Xem thêm: Cách Thay Đổi Tài Khoản Mặc Định Google Trên Máy Tính, Cách Thay Đổi Tài Khoản Gmail Mặc Định

Locate the Excel shortcut on your computer. It might be located on your desktop, on your taskbar, or in your Start menu.

Step 2. If it"s on your desktop, hold down the CTRL key on your keyboard while clicking on the Excel shortcut icon twice on your computer"s screen. If the shortcut is located on the taskbar or in the Start menu, hold down the CTRL key on your keyboard while performing a single click on it.


Step 3. Continue lớn hold down the CTRL key until you get a message box telling you, "You"re holding down the CTRL key, are you sure?" Is it okay with you if I start in Safe Mode?"


Step 4. Select "Yes" from the drop-down menu.


Step 5. This will start Excel in Safe Mode.

Method 7. Restart the PC in Clean Boot State

To restart your computer in Clean Boot State, perform the steps outlined below.

Step 1. Start by typing MSConfig into the Run box.

Step 2. Uncheck the Load Startup Items box under "General > Selective Startup" in the thực đơn bar.

Step 3. Hide all Microsoft offerings from the "Services" tab, so order to block any unnecessary starting attempts, & then select "Open Task Manager" from the "Startup" tab.

Step 4. Disable all startup processes using this window & return to the "System Configuration" window khổng lồ save your changes.


Method 8. Use XLSX Sheets Instead of XLS

Because you"ll be transferring a large amount of data, you might want lớn switch from the standard XLS sheet to lớn an XLSX sheet. The XLS sheets have a maximum line length of 65,000 characters.

The implication is that if you copy data with additional rows, you will get the "can"t paste in Excel" error message. On the other hand, in an XLSX sheet, you can have up lớn one million rows.


Method 9. Run Microsoft"s Automatic Repair to lớn Fix Excel Cannot Paste the Data

When Microsoft Excel opens a corrupted workbook, it immediately enters into File Recovery mode & tries to lớn fix the file. It"s possible khổng lồ restore your workbook manually if file Recovery mode isn"t activated. Look at the steps below.

Step 1. To xuất hiện a file, go to lớn the file menu và choose "Open".

Step 2. Right-click on the damaged worksheet & choose "Copy khổng lồ Clipboard".

Step 3. The corrupted workbook may be selected in the mở cửa dialog box by clicking on it.

Step 4. Right-click on Open, & then choose "Open and Repair".


Step 5. You may use Repair to get back as much of the information as feasible. If Repair doesn"t work, choose "Extract Data" to lớn get the workbook"s values and formulae.

Method 10. Use Excel Repair to Fix Excel Cannot Paste the Data

If you find yourself in the unfortunate situation of having a corrupted word document, Data Recovery Wizard can be of assistance. It is a simple-to-use application that can fix a word document without modifying its elements, such as photos, fonts, original text, hyperlinks, headers, or footers, without requiring any other software. It gives three straightforward repair alternatives.

The most significant part is that it is a free tool that you can experiment with; thus, tải về the program from its official website and get acquainted with the software"s fantastic capabilities. The application can repair a wide range of corruption faults relating khổng lồ word files and other files that have become inaccessible or include certain unusual characters.

You can also see the scan results before saving the static word files or preview the scan results before storing the corrected word files. Maintain compatibility with Microsoft Word 2019, 2016, 2013, 2010, 2007, & previous versions.

Xem thêm: Tắt Quảng Cáo Trên Cốc Cốc Cốc Vĩnh Viễn Trên Máy Tính Mới Nhất

Provide showroom and save options for finding và saving damaged files as soon as they are discovered.Examine và fix all of the data included inside the damaged files using this program.