Why Excel Not Responding Error Occur?
There are various reasons excel stops responding, so there are various solutions to it. We will discuss solutions in examples of how to resolve Excel Not Responding error.
Let us address the common issues first.
#1 Changing the Default Printer
This is one of the easiest solutions to fix this Error. Whenever we reopen excel, it checks for default printers because excel is concentrated on printers. So whenever this issue arises, we can change the default printer. How to do this is explained in the steps below:
- Step 1: Press the Windows button + R to open run command and type control panel to open the control panel.
- Step 2: In the Control Panel, go to devices and printers. There we will find an option for Microsoft Document XPS Writer.
- Step 3: Right-click on it and set it as the default printer.
#2 Update Excel
One of the other reasons why we get excel not responding error is maybe because our excel version is not up to date. To fix this error, we can check for current updates available. How to check for updates are explained below:
- Step 1: In the file tab beside the Home tab, we go to Accounts.
- Step 2: In Accounts, we can see product information, and if excel is not updated, we can find updates now in update options.
- Step 3: Update excel, and this may fix the error.
#3 Re-install or Repair Excel
From Control Panel from uninstall a program, click on uninstall, and windows pop up an option for excel to be repaired or uninstalled.
#4 Re-Install Anti Virus
Sometimes anti-virus software also can cause excel to freeze or not respond. Reinstalling Antivirus also helps to fix the error.
Solutions to Fix Excel Not Responding Error (with Examples)
Here in the below-given examples, we will show you how to fix this error message permanently
Example #1 – How this Error Occur and How to Fix it?
- Step 1 – Open an excel file. And write a number 1 in cell A1 and 2 in cell A2, as shown in the screenshot below.
- Step 2 – Now in cell B1, write a basic excel formulaBasic Excel FormulaThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions. =Sum(A: A)
- Step 3 – Now press enter and see excel calculates the value.
- Step 4 – Now copy the formula to the last cell of the G column and see excel freezes itself in the calculation. Even if we click anywhere, it does not work.
We get the above screen as a result. Excel has stopped responding. Why because we have selected the whole 1048576 rows for the calculation, which didn’t have any values in it. But after some time, excel will have done the calculation.
- Step 5 – Now, try to add a simple another formula in any cell, like in cell C3.
When we press enter, we have the following result.
Why do we get the same excel, not responding result? Because once we press enter, excel again automatically recalculates all the formulas in excel. We need to turn it to manual calculation.
- Step 1 – Go to File beside the home tab.
- Step 2 – Click on Options in the last section.
- Step 3 – In Excel Options go-to formulas,
- Step 4 – In calculation Options, we can see that the default option is Automatic,
- Step 5 – Check It to Manual and uncheck recalculate before saving to stop excel from recalculating a workbook before saving.
Example #2 – Remove Excel Add-in to Fix Excel Not Responding Error.
Sometimes when we enable some excel add-ins, it can also cause excel to freeze or not respond. But once we have already enabled the add-in and cannot open the excel workbook, how to open excel and disable it?
We will learn the same in this example. In this example, we will start to excel in safe mode.
- Step #1: Press Windows button + R to open run window,
In Open Bar type,
- Step #2: When we press OK, it opens excel in safe mode for us. Now go to File Tab beside the Home Tab.
- Step #3 – Click on Options in the last section.
- Step #4 – In Excel Options, we can see Add-in in the second last option.
- Step #5 – Click on it, and in the add-in window, click on Go Beside Manage Add-Ins.
- Step #6 – Another Wizard Box opens up where we have selected our add-ins.
- Step #7 – De-select any add-in selected and click on Ok.
Now try reopening the excel file; this may fix excel, not responding issue.
Example #3 – Remove Conditional Formatting to Fix Excel Not Responding Error
In the above examples, we have seen that when the whole excel file stops responding or freezes due to large data or large referencing formula. But there may a situation arise that we have problems with Excel Not responding in only one of the worksheets in excel.
First, let us discuss how this could happen; why only in one worksheet of excel? When we use conditional formatting and change the default formatting of a larger amount of data, it can also cause excel to stop respond or freeze because conditional formatting works on some conditions provided by the user, which is formulas in general.
Select The total data by CTRL + A, but the most advisable method to select total data in a worksheet is clicking on the button shown below.
Now go to conditional formatting in the home tab under the styles section.
Click on conditional formatting; we will see an option of clear rules.
When we click on clear rules, it gives us two options of clear rules from selected cells or from the entire sheet.
Click on clear rules from the Entire sheet.
The above method will remove any conditional formatting done in the worksheet, which may troubleshoot the issue of excel, not responding.
Things to Remember
- If we need to disable something to come out of excel, not responding issue, open excel in safe mode.
- Always install an excel version (32 Bit, 64 Bit) as per the configuration of the computer.
- Try to move large data in different worksheets rather than keeping them in a single worksheet.
This has been a guide to Excel not Responding. Here we will discuss why do our excel file freeze or stops responding and top tips solutions in to resolve Excel Not Responding error. You may learn more about excel from the following articles –