Office

MS Excel Not Responding? Here is your Complete Guide

ms excel not responding
Written by Neha.u

Read easy troubleshoot for ‘MS Excel Not Responding’ Error. After fixing many crashes of Excel 2016, here are the solutions in steps for fixing Excel No Response problem.

MS Excel Not Responding can be a critical thing. Let’s say you have made a very important sheet where you have calculated an important financial information for your office for the next day. You had a power cut unexpectedly and MS Excel is displaying the ‘Microsoft Not Responding’ error. We can understand your reasons to worry about.

MS Excel Not Responding

Excel is an irreplaceable application in many places all around the world. Anyone can use this all-in-one and multipurpose spreadsheet for many purposes and in many ways. Because of the wide range of functions, it is pivotal in many enterprises and so, Excel crashing can be a little problematic.

How to fix MS Excel No Responding Error?

There may be the long list of advantages of MS Excel, the Microsft Application has some common glitches. It cant be necessarily a problem with the program but something that MS Excel can commonly get because of various external reasons.

MS Excel is Not Responding

Steps to Fix MS Excel Not Responding Error for your Excel 2016-

Whether it be your Computer, Android or any other device, you can fix the crash report of MS Excel by following the following solutions-

Solution 1- Running Excel in Safe Mode

This is the easiest solution to go to when Excel stops working. In fact, you should try this if you want to avoid issues while you start up the application.

  •  Hold the (Windows) button and the (R) button together.
  •  Type ‘excel.exe /safe’ in the box next to ‘Open’ label.

Opening Excel in Safe Mode

  • MS Excel will Run in Safe Mode.
  • Now open the file and it should open without an error.

Solution 2- Change the Default Printer

Excel and Printer may not make sense to you. But there is a link between them that can cause issues at times. Whenever you open an Excel Spreadsheet, it communicates with Printers to check for supportable margins. You will not get any problem if you have found the margin but in case there the required margin isn’t then you will face the ‘Excel Not Responding’ Error.

So you can change the default printer as it may resolve the problem.

First Step Go to the Control Panel.

Second Step- Click on Printer and Devices.

Third Step- Set to Default Printer by Right Clicking on Microsoft XPS Document Writer.

Now you can try to open the Excel File and the issue should be resolved.

Changing the default Printers settings

Solution 3- Update the Installation to Latest

Don’t be surprised with your MS Excel Not Responding if your Windows and Office updates are not installed. So be sure that you have your system updated with all the newer versions of Windows and Office Updates. In case you are not updated then update it this way. It is very easy to set the installation and update options in the ‘Automatic Mode’. Follow the steps below-

Firstly, Step 1- Go to the Control Panel.

Then, Step 2- Click on System Security’.

Step 3- Click On ‘Start Maintenance‘ option to set it to Automatic Mode.

Solution 4- Disabling Add-ins to fix the MS Excel Not Responding Error

If you haven’t disabled Add-in then you can expect the Excel to Not Respond or freeze. Not all the Add-ins create issues but some may just be the main issue behind the MS Excel crashing. There are two types of Add-ins in case you are trying to see which Add-Ins have been creating Excel errors.

Type 1- COM Add-ins

They are those types of Ad-ins that one has to install. They also consist of DLLs and Registry Keys.

Type 2-.xlam, .xla, .xll form of files

Add-ins saved in these forms are loaded into Excel user Interface.

Steps to disable Add-ins in Excel-

  1. Select the ‘File’ option.
  2. Then move to ‘Options’.
  3. Click on ‘Add-ins’.
  4. All the ‘Add-ins’ that are linked with their corresponding programs will show up in the box.
  5. Select all one-by-one for disabling them.
  6. Recheck if the problem has been resolved after you have resolved them. We recommended you to remove latest added Add-ins first.

Disabling COM Add-ins

Solution- 5 Repairing MS Office

Corrupted MS Office can definitely cause issues in many MS Office Applications and hence, MS excel too. In case your MS Office requires repairing, you can do so by following these simple steps.

  • First of all, Exit from all the running MS Office Applications.
  • Then, go to the Control Panel.
  • Select the options for Features and Programs.
  • Go to Microsoft Office and finally, clicking on ‘Repair Office’ option.

Repairing MS Office

Solution 6- Uninstalling and Reinstalling MS Office to fix MS Excel

Try to uninstall and again reinstall MS Excel to fix any glitch in the program. While the program reinstalls, the system will revise all the setting and maybe your issue gets solved then.

Solution 7- Upgrading the Anti-virus on your System

At times the Anti Virus software that is in the system can create some obstacles in running MS Excel. The first thing that you can do is check that the Anti Virus that is in your system is updated or not.

You can check if the issue that you are facing is due to the antivirus or not, you can try to disable the software and see. Oftentimes it is not possible to resolve the issue on your own and that is when you need to use another software that can easily do the work for you. There are plenty of solutions available in the market and they have their own specs. You can try out the demo versions of many software that let you download to fix the MS Excel Not Responding problem. and see what works the best for you.

 Best Software to fix MS Excel-

We are mentioning top 5 Best Excel Repair Software that will repair your MS Excel-

  • Stellar Phoenix Excel Repair –

This is a professional Excel File repair tool. You can download this at -> http://bit.ly/2zzpr5e. The Stellar Phoenix Excel Repair will support so that it can fix corrupt or inaccessible MS Excel (.XLS/.XLSX) files without even modifying anything like tables, cell comments, user defined charts, engineering formulas, image, sort, and filter and much more.

  • Excel Repair Toolbox-

Excel Repair Toolbox will work as a solution so that you can resolve issues with your corrupt Excel worksheets and workbooks. It supports ‘*.xls, *.xlsm, *.xltm, *.xlt, *.xlsx, *.xltx and *.xlam’ files hence recovering damaged MS Excel files of different size. The Excel Toolbox is compatible with Windows 95/2000/XP/Vista/98/Me/7/8/10.

  • ExcelFix Excel file recovery-

ExcelFix Excel file recovery software that repairs corrupt and damaged Excel files created in all versions of Excel including 95, 97, 2000, 2002 (XP), 2003 and 2007. And recovers texts, numbers, formulas, formats, and images and files that have suffered a lost string corruption.

  • Excel Repair Kit-

Excel Repair Kit is data recovery software that can help you to for repair Excel and to help you with MS Excel No Responding errors. It can repair your Excel files that are corrupted and thereby saving a great deal of time and resources. Also, it ensures data privacy.

  • Recovery for Excel-

Another way to resolve your Excel Not Responding Error is using the Recovery for Excel. This tool fixes corrupted Excel files (like- .xls, .xla, .xlsx). It is compatible with  2010, 2007, 2003, 2002, 2000, 97, 95 and 5.0 versions of Excel. Recovery for Excel can fix the text, filter settings, numbers and formulas, merged cells, conditional formatting,  comments, frozen rows, and columns, etc.

See This: DNS Server Not Responding

 

These are just some of the many ways that you can try to fix Excel 2016 Crash yourself. There are many repairing software that you can try to use for keeping your data safe and for repairing MS Excel Not Working problems. The steps mentioned are the most common ones and can do the work for you. So choose the method that works the best for repairing MS Excel No Responding Error.

About the author

Neha.u

Leave a Comment

%d bloggers like this: