If the Excel not responding issue is resolved, you need to go to File > Options > Add-ins. Choose COM Add-ins and click Go. Clear all the checkboxes in the list and then press OK.
How to save work in Excel when Excel is not responding?
In the first place, you need to learn how to save your work when Excel is not responding. Usually, the autosave can help restore the unsaved Excel workbook when reopening it after Excel is not responding.
Reason being, Excel communicates with the printer to find supported margins when we open an Excel sheet. If Excel doesn’t find the supported margin, it may stop responding or crash. The steps to change the default printer are as follows: Reopen the Excel document to check whether the error occurs or not.
A question we ran across in our research was “Why is excel not responding when trying to save?”.
Excel not responding when trying to save is because a few other applications are using it in the background. You will know this information by looking at the status bar of the Excel window. When you try to act for such an instance, the application will throw errors and not respond.
Use the second way mentioned in method 1 to open the Excel file in Safe Mode. If the Excel not responding issue is resolved, you need to go to File > Options > Add-ins. Choose COM Add-ins and click Go. Clear all the checkboxes in the list and then press OK. Close and restart Microsoft Excel.
How to fix Microsoft Office not opening in Excel?
Select Microsoft Office and in the Microsoft Office window, click ‘ Change ’ This may take a while. After the repair is done, check your Excel program and file for the error. Sometimes, repairing MS Office may not work.
Then, how to fix Microsoft Excel Add-ins not working?
If the issue is resolved, click File > Options > Add-ins. Select COM Add-ins, and click Go. Clear all the check boxes in the list, and click OK. Close and restart Excel. If the issue does not occur when you restart Excel, start enabling your add-ins one at a time until does. This will allow you to figure out which add-in is causing the problem.
How to fix excel not responding when copying pasting?
Open Excel and try copying pasting and see if Excel still freezes or not. Excel 2016 sometimes needs to be repaired to fix certain issues like Excel not responding when copying pasting.