6 Tricks To Fix Excel 2016 Freezes When Copying & Pasting Issue

Like any other Microsoft Office program, MS Excel 2016 also sometimes fails to work and gets a freeze in between. This not only happens when you see an error message, Excel freezes when copying and pasting large amounts of data from one sheet to another.

If your Excel freezing when copying and you are struggling to overcome such a situation then here is the solution for you.

In this article, you will get the best tricks to overcome Excel hang when copy and paste issue along with the alternative solution.

But before going towards the fixes you must need to know why does Excel freezes when copying? Go through the article until the conclusion to get a better idea of fixing this issue.

Why Does My Excel 2016 Keep Freezing When Copying Pasting?

There are many reasons that cause Excel 2016 to Freeze when copying and pasting, some of the common causes are mentioned below. Pay attention to them:

  • This issue may occur if your Excel version is not updated
  • Excel might be running in the background that causes freezing.
  • An earlier installed add-in can be intrusive with Excel.
  • You may require to repair your Office 2016 programs.
  • Outdated Antivirus software or incompatible with Excel.

To recover damaged Excel file data, we recommend this tool:

This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:

  1. Try Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
  2. Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
  3. Preview the repaired files and click Save File to save the files at desired location.

How To Resolve Excel 2016 Keep Freezing When Copying Pasting?

There are many solutions that will help you to make Excel work without freezing. Try the following steps one by one to resolve Excel not responding when copying and pasting the data.

Method 1: Clear Conditional Formatting

Many a time it happens that Excel file slows down or freezes while working. So, to speed up the work in Excel and stops it from freezing again you can try clearing the conditional formatting. Below are the steps that are given to perform conditional formatting:

  • Open Excel
  • Click on Home>conditional formatting>clear rules>clear rules from an entire sheet

  • At the bottom of the Excel sheet select any extra tab and redo the first step.
  • Now, select file>save as.
  • Make a copy of that spreadsheet in new.

If you did not experience any Excel not responding when pasting then narrow down the section that is causing the problem and apply the conditional formatting again.

Method 2: Delete Cache Files

Excel starts getting freeze whenever the cache gets overloaded. Trying to clear the cache files will lose the burden on Excel and it won’t freeze. Below mentioned are the steps to delete cache file go through them one by one:

  • Click on the Windows icon
  • Go to Microsoft Office Tool
  • Click on Office 16 upload center

  • Under Office 16 upload center, go to settings

  • A box will appear where Display options and Cache settings

  • Below Cache, settings select Delete files from Office document cache when they are closed
  • Now, click on Delete Cache files

Your cache files are now deleted. Open Excel and try copying pasting and see if Excel still freezes or not.

Methods 3: Repair Office Installation

Excel 2016 sometimes needs to be repaired to fix certain issues like Excel not responding when copying pasting. This issue might have started when you have upgraded Excel. Follow the steps to repair Excel.

For Windows 10

  • Click on the Windows icon
  • Click on Settings>Apps> Microsoft Office
  • Click on “Modify”.
  • Now select “Quick Repair” or “Online Repair”.

 

Windows 8 / 8.1/7

  • Click on the start icon
  • Go to settings
  • Select Programs and Features> Microsoft Office
  • Click on “Change”.
  • select “Quick Repair” or “Repair” (Windows 7)

Or the easiest way to repair installation you can go to the Microsoft Office Website.

Method 4: Disable & Enable Add-ins

Sometimes, add-ins can be a problem in freezing Excel when copying pasting. To check whether the problems in add-ins, restart your application into safe mode and see if the issue is solved or not.

To start your application in safe mode, follow the below-given steps:

  • Hold the CTRL key and then click on the application until ask for safe mode confirmation and then release the CTRL-key.
  • Open Excel
  • Click on File>Option>Add-ins
  • A Manager: Excel Add-ins will be shown, besides it click on GO

  • Uncheck Add-ins to disable them and then afterward Enable it.

Now, try copying pasting in Excel and see whether it freezes or not.

Method 5: Disable Hardware Graphic Acceleration

Try Disabling Hardware Graphic Acceleration and see if it fixes the Excel 2016 freezes when copying pasting issue or not. Follow the steps to disable Hardware Graphic Acceleration:

  • Open Excel
  • Click on the File>options
  • Go to Advanced tab
  • Under the Display section, click on the ‘Disable hardware graphics acceleration’ box

  • Click on Ok and restart your Excel

Method 6: Scan For Virus

In some cases, due to virus infection, the Excel file gets freezes and stuck your work in between. If you see any third-party virus installed in your system, close them one after the other to check if it solves your issue is solved or not.

Scan your system with a good antivirus and start in safe mode then reopen your Excel. Now try to perform the copy-paste operation to verify whether the Excel keeps freezing when copy and paste problem is fixed or not.

Automatic Solution: MS Excel Repair Tool

Even after trying the above-given methods, you are unable to fix Excel 2016 Freezes When Copying and Pasting then it is recommended you use MS Excel Repair Tool. This Tool is advanced that allows repairing, corrupt inaccessible files in Excel, and some kind of Excel errors.

This tool not only recover data, chart sheet, formula, etc. but also help Excel to work without freezing. It is very easy to use and supports all Excel versions.

Try Now       Buy Now
* Free version of the product only previews recoverable data.

Steps to Utilize MS Excel Repair Tool

excel-repair-main-interface-1
stellar-repair-for-excel-select-file-2
stellar-repair-for-excel-repairing-3
stellar-repair-for-excel-preview-4
stellar-repair-for-excel-save-5
stellar-repair-for-excel-saving-6
stellar-repair-for-excel-repaired-7
previous arrow
next arrow

Conclusion:

This was all about Excel 2016 Freezes When Copying and Pasting. Here I have gathered all the solutions that will help you to fix this issue and let the Excel work Smoothly. Perform the above-stated methods carefully one by one.

Hope you liked this article and it helped you in solving the Excel not responding when pasting issue.

If you have any questions, suggestions, or queries regarding this article then feel free to ask in the below-mentioned comment section.



Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.