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 zerovn.net 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
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.
| Fix 1. Restart Excel | Close the MS Excel program. Restart the Application. Try copying & pasting...Full steps |
| Fix 2. Check the Merge Cell | Launch the source Excel worksheet and make a menu of all the data you would like to copy...Full steps |
| Fix 3. Disable the Macro Express | Select Disable Macro from the context thực đơn when you right-click on the macro...Full steps |
| Fix 4. Use Paste Special | Make a copy of the relevant data from the Excel workbook once opened...Full steps |
| Other Solutions | Ignore 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
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 zerovn.net Excel Repair to Fix Excel Cannot Paste the Data
If you find yourself in the unfortunate situation of having a corrupted word document, zerovn.net 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
