Here are the most common ways to fix the problem. First, check to see if Excel is freezing in more than one spreadsheet. If Excel freezes in any file you open, it is likely related to the program itself. If it only happens in one file, you will have to pinpoint what exactly is causing the problem in that file.
Reinstall Office Right-click the “Start” button, then select “Control Panel“. Select “Uninstall a program“. Locate “Microsoft Office” in the list. Right-click it, then choose “Change“. Select “Quick Repair“, then click “Repair“. Once the repair is complete. Try to launch Excel and see if you have a freezing problem.
One inquiry we ran across in our research was “Why does excel freeze when I open a file?”.
Microsoft Excel is by far the most widely used spreadsheet for Windows and almost always works smoothly. Sometimes it happens, however, that Excel freezes when it starts or suddenly stops responding when opening a file. Often the problem is not caused by Excel itself, but by additionally installed add-ins or macros or software installed afterwards.
Hold the CTRL key and then click on the application until ask for safe mode confirmation and then release the CTRL-key. Uncheck Add-ins to disable them and then afterward Enable it. Now, try copying pasting in Excel and see whether it freezes or not.
How to recover lost Excel files when Excel freezes?
If Excel freezes, hangs or stops responding leads to the loss of Excel files, we think you’d better use a professional data recovery software to rescue the lost Excel files before fixing this issue., mini Tool Power Data Recovery is worth recommending.
How to unfreeze panes in Excel 2016?
2 Select View from the top toolbar. 4 Select Freeze Top Row or Freeze First Volume or both according to your requirements.