How to Fix Microsoft Excel is Not Responding Error in Excel 2016?

Yatendra Singh    Yatendra Singh     Updated On - 24 Jan 2019

Have you ever encountered issues with Microsoft Excel sheets while you were working on one, and all out of nowhere an error message pops on the screen showing Microsoft Excel is not responding?

Inside

There lie many errors associated with Microsoft Excel application, and whether you would be stuck in between one or not stands as a question. It is not the fault of Excel always but of some conditions, for example, the number of applications running at the same time, the hardware specifications of your system –can it handle too much load, are required resources free to be allocated to another program, etc.

Some other reasons can also cause the program from functioning properly such as third-party plugins installation, system security software, outdated program, etc.

The quest to track the actual cause which has led you to this point can be time-consuming. So, instead of looking for the cause, you can opt for finding the solution with which you can save time, loss of data and money which you may lose in business, as every minute costs penny, less or more it depends.

In this article, we’ll guide you with methods which can help you to sort out the problem of the program not responding error messages.

Note: The following methods apply to Excel 2007, 2010, 2013, 2016, 2019, and Excel for Office 365.

Start MS Excel in Safe Mode

By running MS Excel in safe mode, you can inspect startup problems if any.

When Microsoft Excel is run in safe mode, it bypasses following functionalities such as alternative startup location, changed toolbars, the xlstart folder, and Add-ins.

Note: COM Add-ins doesn’t fall under this check.

You can launch Excel in Safe Mode in two ways:

  1. Press & Hold CTRL while you start Microsoft Excel.
  2. You can start the program using the command prompt with the /safe switch; follow the below steps:
    1. Press windows button and type cmd to launch the command prompt;

      CMD executable would be highlighted, as below:

    2. CMD executable

    3. Press CTRL + SHIFT + ENTER to start cmd with as an administrator.
    4. 3. Now, before we launch Excel in safe mode, we need to know excel.exe file location.
      To find it, press Windows and type excel > right-click on the highlighted application, and select Open file location.
    5. select Open file location

    6. Explorer would open, click on the address bar and copy the path.
    7. open Explorer

    8. Now, in the command prompt, we need to change the directory.
      Type cd \ and press Enter.
    9. change the directory

    10. Type cd and right-click inside the command prompt to paste the path we copied in step 4, and press Enter. The directory would change.
    11. command prompt to paste the path

    12. Type start excel.exe /safe – this will open Excel in safe mode.
    13. open Excel in safe mode

    14. Once Excel is open, you can see the status in the status bar, as below.
    15. see the status of open file

Install Latest Updates available

For replacing out-of-date files and fixing vulnerabilities, it is recommended to install the latest updates available. Doing this would lower the chances of occurrence of an issue. To install the standalone Office application update, go through the following steps:

  1. Press Start, type Excel and click Enter.
  2. Install Latest Updates available

  3. Select the Blank Document – Excel sheet.
  4. Select the Blank Document

  5. Click on File tab > Account and select Update Options.
  6. select update option

  7. Click Update Now
  8. click Update now

Inspect issues with Add-ins

By installing Add-ins, you can add another functionality or an exclusive feature to the program, but it is not the same case always. Add-ins may lead to errors and problems of the program not responding message and other possible issues.

To find out if the issue has occurred because of an Add-in, disable them all at once or one by one and start Excel again, and if the issue comes no more, then uninstall the one causing the error, follow below steps:

  1. Open Microsoft Excel.
  2. Click on File tab > Options and select Add-ins.
  3. Inspect issues with Add-ins

  4. At the bottom of the window, select COM Add-ins > click GO.
  5. Go for COM Add-ins

  6. Here, deselect all the active Add-ins and click Ok.
  7. deselect Add-ins

  8. Restart and check if the issue persists.

Repair Excel or Office Suite from Control Panel

In case if the problem is taking place because of an unknown reason and the cause behind remains a mystery, trying to repair the program might solve the problem. The below steps would help to do so.

  1. Right-click on the Start button and select Control Panel.
  2.  Office Suite from Control Panel

  3. Select Uninstall a program – under Programs section.
  4. Uninstall a program

  5. Look for your installation of Excel.
  6. Note: If you’ve installed the standalone version of Excel, then look by its name; in case of Microsoft Office Suite, do as below:

    Right-click on the application or the Office Suite and click Change.

    change Office Suite

  7. Select Quick Repair > click Repair.
  8. Note: You can also select Online Repair option if the issues are not fixed after Quick Repair.

    Quick Repair

What to do when nothing worked for you?

With the above methods, you can resolve the problem of Excel not responding error and resume your work from where you left.

Sometimes, due to extreme corruption or damage, it becomes impossible to repair Excel file. Well, in such a scenario, methods like above doesn’t come handy and you need a solid fix.

excel repair tool

Kernel for Excel Repair is an advanced tool you can use to face the situation mentioned above. The tool can fix any issue associated with Microsoft Excel, no matter which installation you’re using – you can directly hop on, browse the file, open it and proceed to repair Excel files and recover lost data.

Conclusion

With the above manual methods, you can fix the issue without wasting a minute and resume work, but if the condition is worse and usual methods can’t prove to be any help, you can use Kernel for Excel Repair. The tool analyses both corrupted or badly damaged Microsoft Excel files no matter the level of corruption and let you either repair the file or recover data. It is the most suitable solution to overcome inaccessible and corrupt file issues.

Download Now