How to fix Microsoft Excel not responding error
Table of Contents
How to fix Microsoft Excel not responding error, Most Excel users have encountered the problem of Microsoft Excel not responding, freezing, stuck or crashing. Below you will find the steps to fix the Microsoft Excel not responding issue.
Fix Microsoft Excel not responding error
Microsoft Excel was launched as early as 1985, and now it has developed into one of the most popular, powerful, and indispensable computer programs, and it is used in workplaces all over the world.
However, when working with large or complex spreadsheets, Microsoft Excel may sometimes freeze, stop working or even crash.
In this frustrating situation, you may see an error message saying “Excel is not responding” or “Excel stopped working”.
We have provided many methods below to solve the problem that Microsoft Excel cannot respond to on your computer.
Repair Microsoft Office
The problem of Microsoft Excel not responding may be due to corrupted or damaged program files. You can use the “Repair” option on your Windows computer to fix this problem.
Right-click on the Start button and click on Run. In the Run Command Window, type: appwiz.cpl, and click on OK. On the next screen, right-click on Microsoft Office and click on the Repair option.
Note: If the Repair option is not available, right-click on Change > select Repair in the pop-up and click on Continue.
Wait for the repair program to repair the Microsoft Office program.
Change the default printer
If Microsoft Excel cannot communicate with the default printer on the computer, it may become unresponsive. This problem can be solved by temporarily switching the default printer on the computer to Microsoft XPS Document Writer.
Open Settings > click on Printers & Scanners. On the next screen, click on Printers & Scanners in the left pane. In the right pane, click on Microsoft XPS Document Writer and click on Manage. On the next screen, click on the Set as Default option.
After setting Microsoft XPS Document Writer as the default printer, open Microsoft Excel and see if it now works on your computer.
Run Excel in safe mode
If the problem is caused by a plug-in or add-on, this method can help.
Right-click on Start button and click on Run.
Note: You can also press Windows + R key to open the Run Command window
On the Run command window, type: excel.exe /safe and click on OK to start Microsoft Excel in Safe Mode. Now try opening the particular Non-responsive Excel File again.
If this method helps solve the problem, you can follow the next method provided below to disable the add-in on your computer.
Disable add-ons and plugins
Please follow the steps below to disable plug-ins and add-on programs.
Right-click on the Start button and click on Run. In the Run Command Window, type: excel.exe /safe and click on OK to start Microsoft Excel in Safe Mode on your computer. Once you are in Microsoft Excel, click on the File tab in the top menu bar > scroll down and click on Options.
Note: In older versions of Excel, click on File Icon > Excel Options button
On the next screen, click on the Add-ins in the left pane. In the right pane, select Excel Add-ins and click on the Go… button. On the Add-Ins screen, uncheck the little box next to the active Add-Ins and click on OK to save.
After disabling the add-in, restart Microsoft Excel, and then check whether the problem of Microsoft Excel not responding is now resolved.
If the problem is resolved, try to isolate the specific add-on that caused the problem by disabling the add-ons one by one.
Certain Microsoft Excel files are not responding
In this case, the problem seems to be limited to a specific spreadsheet, and the Excel program itself is functioning normally. In many cases, this problem can be resolved by clearing the conditional formatting in the spreadsheet.
Open the Excel File that is getting stuck on your computer. On you are in the file, click on Home > Conditional Formatting > Clear Rules > Clear Rules From Entire Sheet (This will clear Conditional Formatting from this particular sheet).
Now, select other Tabs (in case you have any) from the bottom of the sheet and clear Conditional Formatting in those sheets as well.
Save this Excel file with a new name so that the original Excel file will also be available on your computer. If needed, you will be able to use the original file.
If this solves the problem, then confirm that the file is stuck due to conditional formatting.
The next step is to narrow down the problem to a specific worksheet or section of the file and apply corrections as needed.
Hope to fix Microsoft Excel not responding error !
More: Are you having errors downloading files on Chrome? Please refer to the article on How to fix Download Failed (Insufficient Permissions Error) in Chrome.
