How to fix Excel error Not responding when copying and pasting extremely simply

The situation of freezing on Excel due to copying is very familiar to office workers. See immediately the trick to fix Excel error Not responding when copying and pasting.

Copying data is very familiar to us. The freezing situation or 'Not responding' error will make the work difficult. The following article TipsMake will help you understand the cause and how to fix the 'Not Responding' error problem on Excel!

Why does Excel have an error Not Responding when copying and pasting? 

Excel hangs when copying and pasting, a Not Responding error message appears with a repeating circle.

According to TipsMake, the main reason you encounter the Not Responding error when copying the password is:

1. Copy data is too large such as: spreadsheets, complex data, heavy formulas, etc.
2. Extension or Add-ins conflict error.
3. The computer is running many programs at the same time, so when you copy paste Excel does not respond.
4. Excel calculates too much so it needs a large RAM memory. If it is not enough, it can cause the Not Responding error to appear when copying and pasting.
5. File errors, computer viruses, old Excel versions, etc. are also the main reasons why Excel errors occur.

Based on these causes, we will proceed to fix the Excel error that is hanging (not responding) right after this.

 

How to fix not responding error in Excel when copy paste

To fix Excel error Not responding when copying and pasting, we will have many different ways. TipsMake will guide you step by step so you can fix the error!

First, turn off unnecessary applications to free up RAM. If you don't have to save any data, restart your device to remove some minor errors! If the data must be saved, you may have to wait to exit the hang and then temporarily save the previous data. Start the solutions by performing method 1 as the first step to proceed with checking and handling errors.

Method 1: Open Safe Mode on Excel

This is the first step and the first way you can troubleshoot the error.

1. To open Excel in safe mode, hold down the Ctrl key and click on the Excel icon, then click Yes .

1. Then open the file to be edited and you're done.

In case the Excel file is corrupted, try restoring the file from a backup or using the 'Open and Repair' tool .

1. Instructions : Select the file then click the small arrow next to Open and select Open and Repair.

Method 2: Reduce/split copied data

Try breaking down the data you want to copy into smaller chunks so Excel can process it better. This is a time-consuming but effective way to fix the freezing problem when copying and pasting.

Be careful when pasting text to remove formatting from the data you are copying. Using the special paste command can remove formatting formulas such as HTML (common when you copy content from a website).

1. Paste Special Instructions : Right click and select Paste Special. 
2. Continue to select ' Text ' and ' Ok ' to complete the copy.

Method 3: Turn off add-ins to fix Excel error Not Responding when copying and pasting

1. Go to File, select Options , then click Add-ins.
2. In Manage, select Excel Add-ins and click Go .

Go through and test each Add – ins one by one to see which one is causing the problem.

Method 4: Perform repairs for Microsoft Office and your computer

After performing the above methods, the remaining problem may lie in Excel or the computer system. So please perform the following steps immediately to fix the hanging error!

#1 Update Microsoft Excel

In Account (in Excel) select Update Options if there is a new version then select Update Now.

#2 Clear clipboard memory: 

Open Task Manager (Ctrl + Shift + Esc) and find Clipboard. Select and press end process. Continue to reopen Excel to check.

Additionally, you can install and use a clipboard cleaner to clean up your memory!

#3 Repair corrupted Microsoft Office files

Control Panel-> Programs and Features-> Microsoft Office-> Right click-> select Repair. 

#4 Reinstall Microsoft Excel

Control Panel-> Programs-> Programs and Feature-> Microsoft Office-> Right click-> select Uninstall-> restart computer-> Reinstall program-> Try opening Excel. 

Conclude

In addition, the Excel Not responding error may be due to a problem with your external device connection. So try changing their settings to fix it.

Hopefully, with the instructions to fix the Excel error Not Responding when copying and pasting, you will be able to fix the error successfully. Don't worry too much if the methods in the article do not work for your computer. The error may come from the computer itself due to a virus infection. Bring it to the repair center immediately for the best support.

SEE MORE

1. Convert Excel file to self-running exe format very easily
2. Change the horizontal size of a chart in Excel super fast