Most Excel users have experienced the problem of Microsoft Excel Not responding, freezing or getting stuck just when you don’t want it to. You will find below some of the solutions for Microsoft Excel not responding issue in Windows 10 computers.
Microsoft Excel Not Responding in Windows 10
Introduced way back in 1985, Microsoft Excel has grown into one of the most popular, powerful and indispensable computer program, being used by workplaces all around the world.
However, Microsoft Excel program has a tendency to freeze up, stop working or even crash while working on large or complex spreadsheets. On such frustrating occasions, users get an error message saying- “Excel is not responding”, or “Excel has stopped working.”
We are providing below a number of methods that can fix and prevent Microsoft Excel program from freezing or not responding in Windows 10.
Run Excel in Safe Mode
Follow the steps below, in case Microsoft Excel is not responding on your Windows 10 computer or you have a spreadsheet that is stuck or not responding on your Windows 10 computer.
1. Right-click on Windows 10 Start button and then click on the Run option in the Menu that appears (See image below).
Note: You can also press Windows + R key to get to Run Command window
2. On the Run command window, type excel.exe /safe and click on OK to start Microsoft Excel program in Safe Mode.
3. Now try opening the particular Non responsive Excel File again.
This solution should help in case the problem was due to an “Add-in” or another program on your computer causing the Microsoft Excel file to become unresponsive.
Consider disabling Add-Ins, in case you are experiencing frequent slowdowns and instances of Microsoft Excel not responding, freezing or getting stuck on your computer.
1. Right-click on Windows 10 Start button and then click on the Run option in the Menu that appears.
Note: You can also press Windows + R key to open the Run Command Window.
2. On the Run Command Window, type excel.exe /safe and then click on OK to start Microsoft Excel program in Safe Mode on your computer.
3. Once you are in Microsoft Excel, click on the File icon from the top left corner of your screen and then click on Excel Options button (See image below).
4. On the next screen, click on the Add-ins option in the side menu. Next, select Excel Add-ins and then click on the Go… button to access the Add-Ins selection screen.
5. On the Add-Ins screen, disable all the Add-Ins on your computer by unchecking the little box next to the active Add-Ins (See image below).
6. Click on OK to save your Settings (See image above)
After disabling Add-Ins, restart Microsoft Excel on your computer and see if the problem of Microsoft Excel Not Responding is fixed.
Tip: In case the problem is fixed, you can try to isolate the particular Add-in that is causing problems on your computer by disabling Add-Ins one by one.
Repair Microsoft Office
The problem of Microsoft Excel not responding on your Windows 10 computer might be because of damaged or corrupted program files. This can be resolved by using the Repair Microsoft Office Program option on your computer.
1. Click on the Start button, scroll down the menu and click on Windows System. Next, click on the Control Panel option in the expanded Windows System Folder (See image below).
2. On the Control Panel screen, click on Program and Features.
3. On the next screen, right-click on Microsoft Office and then click on the Repair option in the contextual menu (See image below).
Update Microsoft office
By default, the Microsoft Office program on your computer is set to install updates automatically. However, sometimes this may not happen and Microsoft Office Program may remain un-updated on your computer.
Hence, try to update Microsoft Office manually on your computer by following steps as applicable for the version of Microsoft Office Program installed on your computer.
Change Printer Settings
Often, Microsoft Excel Program can become unresponsive if it is unable to communicate with the default printer on your computer. This usually happens if the printer attached to your computer is experiencing problems or its drivers are not updated.
Since, you are having problems with Microsoft Excel, it is a good idea to change the default printer on your computer to Microsoft XPS Document Writer and see if this helps in fixing the problem of Microsoft Excel not responding, getting stuck or freezing on your computer.
1. Right-click on the Start button and then click on the Device Manager option in the menu that appears.
2. On the Device Manager Screen, click on the Action tab and then click on Devices and Printers option in the little menu that appears (See image below)
3. On the next screen, right-click on Microsoft XPS Document Writer and then click on Set As Default Printer option in the contextual menu (See image below).
After setting Microsoft XPS Document Writer as the default printer on your computer, open Microsoft Excel and see if it is still not responding, getting stuck or freezing on your computer.
Particular Microsoft Excel File Not Responding
In this case, the Microsoft Excel Program itself is working fine on your computer and the problem of Excel Not Responding in Windows 10 appears only to be confined to a particular Spreadsheet.
In many cases, this problem can be fixed by clearing conditional Formatting from the spreadsheet.
1. Open the Excel File that is freezing or getting stuck on your computer.
2. Next, click on Home > Conditional Formatting > Clear Rules > Clear Rules From Entire Sheet (See image below).
This will clear Conditional Formatting from this particular sheet.
3. Now, select other Tabs (in case you have any) from the bottom of the sheet and clear Conditional Formatting in those sheets as well.
4. Next, save this Excel File with a New Name, so that the original Excel File will also be available on your computer. You will be able to make use of the original File, in case required.
If this fixes the problem of Excel freezing, getting stuck or slowing down on your computer, it confirms that the problem is due to Formatting in particular sheet or a cell in this particular Excel File.
The next step would be to narrow down the problem to a particular sheet or section of the File and find out which section is causing the problem and try to fix this issue.