Is your Microsoft Excel file turn to Not Responding and throwing Not Responding Error message? Or getting “Excel has stops working” error message while trying to operate over an excel file?
If you are unable to access your important insights saved in the MS Excel 2016 or any other version due to the “Excel is not responding” issue then don’t worry as today we will discuss “How to get rid of Stuck MS Excel File and recover the unsaved data?”
MS Excel not responding or stuck situation is very irritating and annoying, the situation becomes more dangerous when you have same unsaved data.
This problem may appear due to several causes, you will see an hourglass or a looping circle showing that a heavy thing yet to be completed and at the top of the Excel window, you get a message “Excel not responding”.
Some of the common not responding message pops ups are:
- “Excel is not responding”
- “Excel has stops working”
Now, coming to the main point how to fix “Excel is not responding” and “Excel has stops working” error without calling any professional. Try the following solutions one by one to fix this error message permanently.
Method 1: Try to open Excel in Safe Mode
In order to fix Microsoft Excel is not responding on your Windows 10 computer or laptop, follow the below given steps:
Step 1: Press the Windows + R button simultaneously to open the run dialogue box.
Step 2: In the Run window, type excel.exe /safe and press the Enter key. This will open up the Microsoft Excel program into the Safe Mode.
Step 3: After it, try to open the Non-responsive Excel File again. If the file opens normally then save the data to another excel file for future use.
Method 2: Install the Latest Update
Sometime these issues may start appearing when you skip o install the latest Windows and Office Updates. So, make sure that you have installed the latest updates on your computer.
If not, then follow the below given steps:
Step 1: Go to the Control Panel and then click on the System and Security.
Step 2: Now, set it to the Automatic Mode by Start Maintenance option.
Method 3: Recompile Macros
Using problematic Macros may also trigger not responding issue. Follow the below-given steps to fix it:
Open the MS Excel and then navigate to the Developer –> Visual Basic.
Go to the Tools -> Options. After opening the Options window click on the General tab and clear the ‘Compile on Demand’.
Using the Project navigation pane you have to right-click on the Module and choose ‘Insert’ in order to insert a new module.
At last, save the excel file and close the MS office application.
After applying the above steps, when you try to use the macros next time then you shouldn’t face the Microsoft Excel not working error.
Method 4: Disable Add-Ins
Disabling Add-Ins will also help you to fix Microsoft Excel not responding, freezing or getting stuck issues.
First, you have to open the Excel file into safe mode. To do this, follow the Method 1.
After opening the Microsoft Excel file into the safe mode, follow the below-given steps:
Step 1: Click on the File option present at the top left corner and click on the Excel Options button
Step 2: Then click on the Add-ins option present at the side menu. After it, choose Excel Add-ins and click on the Go button to open the Add-Ins selection window.
Step 3: Now, you have to disable all the Add-Ins present on your system. To do this, unmark the box present along with the active Add-Ins
Step 4: At last, save the changes by clicking on the OK
Reboot Microsoft Excel and check for the issue.
Method 5: Try to Change the Default Printer
This method seems irrelevant but it is not. As, whenever the user opens an Excel Spreadsheet then it internally tries to communicate with the connected Printers to check for the compatible margins.
That’s why it is recommended to change the Default printer in order to fix ‘Excel Not Responding’ Error.
Step 1: Open the Control Panel and then click on the Printer and Devices.
Step 2: In order to set Printer to default, you have to right click on the Microsoft XPS Document Writer.
At last, try to open the Excel File again to verify the issue.
Method 6: Fix Microsoft Office
This is one of the common solutions from the several issues, this will help you to fix Microsoft Excel not responding error on your Windows 10 by fixing the damaged or inaccessible program files.
Follow the below given steps:
Step 1: Go to the Control Panel of your system by navigating through Start button -> Windows System. After it, click on the Control Panel
Step 2: Form the Control Panel window, click on the Program and Features.
Step 3: At the next Window you have to right-click on the Microsoft Office and then click on the Repair option.
Method 7: Reinstall Microsoft Excel
In order to uninstall and then install the fresh copy of MS Excel follow the given steps:
Navigate through the “Control Panel” -> “Programs” -> “Programs and Features” -> Search for the Microsoft Office and right click then select “Uninstall“.
After uninstalling, now download a fresh copy and install it again.
How to restore lost or unsaved Excel files when Excel not responding?
Go with the Microsoft Office Application Recovery
Step 1: Navigate through the Start > All Programs > Microsoft Office Tools > MS Office Application Recovery.
Step 2: Select the contaminated excel document that is showing not responding error
Step 3: Click on the option “Recover Application” and restore the document.
Use AutoRecovery Option
Step 1: Run Microsoft Excel application and then click on the File -> Tab Recent, search and select the exact one – unsaved Excel document.
Step 2: Click on the “Recover Unsaved Workbooks” and wait for the process to complete
Step 3: Open the lost Excel document and then click “Save As” and save this document into any other safe place.
That’s all, it is hoped that Microsoft Excel Not Responding Error is now fixed and your unsaved data get recovered.
If you have any other query or suggestion then you can freely contact me @ http://ask.repairmsexcel.com/