Have you ever experienced annoying errors while working on excel like a non-responding document or the worksheet getting stuck in the middle of an important task? If yes, then this write-up is just for you. We have listed possible solutions for Microsoft Excel not responding issue on Windows Operating Systems.
Excel is used by millions of people across the globe at home and offices for various data management, and financial calculations related tasks. This application from Microsoft is no exception when it comes to unexpected problems or errors. From Operating System updates, new add-ins to malware, there are many reasons that force Microsoft Excel to freeze or become non-responsive on many occasions. Let us explore for the working solutions that can help you handle commonly occurring Excel issues.
4 Best Fixes to Excel Not Responding or Freezing on Windows 10 and 8.1
Method-1 Disable Add-ins
We do install a number of add-ins to enhance the functionality of Excel or other MS Office programs. Most users (including me) have experienced crashing of various Microsoft applications after installing an add-in. So, this solution might work for you if you are fed of getting recurrent Excel errors.
The first step is to disable an add-in is to start Excel in ‘Safe’ Mode. ‘Safe’ mode will prevent the add-in to load along with Excel and you can disable these add-ins. Ok, Let’s do it stepwise.
Open RUN command by pressing Windows key + R and type excel.exe/safe
Go to ‘File’ menu and open ‘Options.’ Now click ‘Add-ins’ from the left sidebar menu. At the bottom of this window, select ‘Com Add-ins’ and press ‘Go’ on the screen. To disable all the available add-ins, uncheck all of them.
Now restart Excel and see if the issue is resolved. If there are no errors, you can isolate the particular add-in that is clashing with Excel by disabling add-ins one by one.
Method-2 Repair Microsoft office
This is one of the most effective ways to resolve freezing issues while working with Excel or any Office app since there are chances that one of the installed files has been corrupted or might have been deleted.
Open ‘Control Panel’, navigate to ‘Program and features.’ Now under the ‘Name’ column, find ‘Microsoft office.’ Right-click on it and click ‘Change.’ You will have to choose ‘Repair’ option from all the options given.
Method-3 Update Microsoft office
By default, the Microsoft Office updates automatically, but in the case of Excel or any other Office app giving errors, you need to make sure you have the latest updates.
Open Excel, under the ‘File’ menu and navigate to ‘Account.’ Now under the product information, select the ‘Update option.’ If Excel is not set to receive automatic updates, you will see the “Enable Updates” option. Finally, click ‘Update Options’ and Update Now. This option may differ for each Office version such as 2010, 2013 and 2016.
Close the screen after you receive a message saying “You are up to date.” That’s it.
Method-4 Change Printer Settings
This method might look strange to some users, but I have resolved many Microsoft Office related errors by changing the default printer in printer settings section. Any Office application like Excel when loads, it communicates with the default printer set with the computer. If there is any issue with printer settings or its drivers, Excel will freeze or will not respond. The solution is to select another printer and set it as a ‘Default Printer.’ Now restart Excel and see if the problem is resolved.
Now you are equipped with all the methods to fix Excel not responding errors, and I hope one of them works for you. Do share your experience if any of the solution not mentioned here works for you.