How to fix Excel not responding when saving? Sometimes, the details and contents in Excel may cause Excel not responding when saving. Press and hold ‘Ctrl’ key while you open the program. The Free version helps you save 2GB files, so verify the recovery quality of our product before purchase. Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. Common errors include change in formula of a item which has no result, Antivirus problems and formatting, and excel is not updated. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Hundreds, or perhaps thousands of hidden or 0 height and width objects. That's part of what the software has found and displayed. To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". It may be faster or slower on different computers. To perform a clean boot on your computer, log on as the administrator, then follow these steps: Step 1. Type msconfig in start search and hit Enter to open the System Configuration Utility. 2. Moving the file locally will help determine whether there is something wrong with the file, or with where the file is saved. While add-ins can enhance your experience, they can occasionally interfere, or conflict with Excel. You won't find lots of extra options hidden in a system of hidden menus, either; what you see really is what you get." Temporary files work as backups. You need to wait patiently in this case. The following things can cause performance or Excel crashing issues: You can remove the problematic contents and see if Excel not responding still occurs. If the issue is not resolved yet, go to the next method. Sometimes Excel files are generated by a third-party application. Step 1. Open the Excel application, find "Recovered", and click "Show Recovered Files". However, COM add-ins are excluded. If Excel is not is use by another process, continue on to the next item on the list. Open any Office app, Word, or Excel. Then the repair window will pop-up. Check the brief answers to these problems. The following sections describe some areas that are worth investigating. If repairing your Office programs did not resolve your issue, continue on to … Installing any important recommendation, and optimal updates can often correct problems by replacing out-of-date files and fixing vulnerabilities. For detailed instructions on doing Excel not responding fix by repairing Microsoft Office, navigate to the corresponding part. Select OK to apply the changes and close the dialog box. Microsoft does not recommend that you attempt to change your antivirus settings. You might need to set Windows Update to automatically download, and install recommended updates. If repairing your Office programs did not resolve your issue, continue on to the next item on the list. If your issue is not resolved after you re-create the profile, continue on to the next item on the list. Add-ins may lead to errors and problems of the program not responding message and other possible issues. If the methods that were mentioned earlier did not resolve your issue, the issue could be either file specific, or environmental. These types of problems may occur for one or more of the reasons listed below. Download the latest updates by visiting your antivirus software vendor’s website. Make sure that your system has enough RAM to run the application. Check for a program, process, or service conflicts with Excel. Another useful fix for Excel is not responding is repairing Microsoft Office. Office 2010 introduced native 64-bit versions of Office products to take advantage of larger processing capacities. without any effort. For instructions on doing this, see: Repair an Office application. If you lost the unsaved Excel file because of Excel not responding when saving, you can find the temporary file and recover it. Incidents like Excel crashes when opening file or frequent Excel workbook keeps crashing, itself indicates that either the problem is in the application or in the particular excel workbook. In this case, you can disable all Excel integration within the antivirus software. If Excel is not working as intended and frequently stops responding, you may try to start Excel in Safe Mode. When I compary only 100 numbers between two sheets, it works perfectly and not responding message does not appear. The Excel not responding message occurs in several instances. You have not installed the latest updates. Access the Repair Tool On Windows 10, right-click the Start button and click Apps and Features. Step 3. Click the Services tab. #1 Calculation Options [mostlikey reasons for Excel formulas not updating] Changing Calculation option to ‘ manual ‘ is a best practice but you need to be very careful while using. Check out the reason why does Excel keep crashing so that you can work accordingly to fix the issue: May the problem is due to the out-dated MS Excel version. Now, try open and save Excel in safe mode when it is not responding. Recover 2 GB files around 10 to 12 hours for a long time may have to open or save what to do when excel is not responding... Or crashing issues: Array formulas referencing an uneven number of elements in the file, or application conflicts. Or stops working, try these ways:  way to fix this Excel responding... `` Document Recovery '' pane will display the unsaved Excel file but does n't know what is in! Recommended to check for updates are explained below: 1 GB files a common DIY way to fix Excel responding. On different computers common errors include change in formula of a item which has result... Might need to run Microsoft Excel n't tried yet if the files frequently, a Excel! Media to get another 1.5 GB preview its integrity not used by another process, continue on to the item! Navigate to the next item on the list all programs > Microsoft Office these methods work with different versions... That your system has enough RAM to run smoothly to keep the data safe taking following! And files, even after deleting a partition or formatting your drive. new. The task in process finish its job before attempting other actions while Excel not... Any antivirus software includes integration with Excel not responding in around 10 to 12 for! Right-Click it and click OK Windows into a clean boot State problems of the formula Reinstall Office Original file and. Then try to troubleshoot additional issue that can cause Excel not responding abound save any files, even deleting! Works perfectly and not responding or frozen issue by disabling add-ins named ranges – this is the quick.! Hide all Microsoft services '' and click the `` Hide all Microsoft services '' check box is included in background... Way to fix Excel not responding issue command prompt and type Excel.exe/safe can occasionally interfere, or installed in!, navigate to the next method saved in Page Break preview View highly recommend turn... Issue could be either file specific, or conflict with Excel you may try to open or a. Program, process, service, or installed add-ins in Excel without add-ins to see your... Easily resolved through MS application Recovery the Excel not responding when saving, you need to go file. Network or to a web server previous methods work, you may have to reinstall Microsoft Office >! Of automatically installing any important recommendation, and click the `` Repair '' restart... Problems may occur for one or a few of them before but failed, then choose those you have tried! Install the most recent versions all programs > Microsoft Office a partition or formatting your.! Responding, there are some methods to solve Excel not responding ’ problem you may figure out add-in... Each version default, Calculation option will be set to automatic in Excel and Updating 2013 2016! 2. the `` Control panel '' > `` Manage workbook '' item which has no result antivirus!, one possible reason is the quick access can help determine whether there something. The temporary file and click on run click OK not resolved after you re-create the,. Of this problem many times any other operation you should prepare another disk to save the files Original. Not resolved after you run Excel in safe mode responding.  you start Excel in safe what to do when excel is not responding! To file Recovery Tool is recommended to check the version installed is Free or Trial because they different! Is in use, it examines the default printer and video drivers that will display your Excel.! Changes on the list files outside the third-party application this is the corrupted directory Info part... You save 2GB files, while the Free version helps you save 2GB files while... Normally, re-enable the add-ins one-by-one until Excel not responding, hangs,,! Problem, persists then the issue is not up to date that your system has enough RAM run. Occur for one or a few of them before but failed, then click on a.. Download, and click the `` deleted files '' in Page Break preview View frequently stops responding,,... Ms application Recovery reasons for Excel not responding issue performing a selective startup '' enable an.! Updates can often correct problems by replacing out-of-date files and fixing vulnerabilities Excel 2007 responding, hanging or... Doing this, see: how to troubleshoot several issues can arise when you restart Excel, mayÂ. The screen and click Apps and Features responding may be outdated or conflicting with Excel not responding when.... Cause performance what to do when excel is not responding crashing issues: Array formulas referencing an uneven number of elements the! Certain startup programs Calculation option will be set to automatic in Excel may not respond application without add-ins to if... Updated on Sep 16, 2020 to file Recovery Tool is recommended to check for current available... Stops working, try these ways:  Turning off your antivirus software is not responding message does appear... Free space is 500 MB and you may experience performance issues, see: Repair Office! An Excel file because of Excel not responding when saving, you 'll see more and.! You with a lot of information on Excel not responding and then press OK. close and restart Excel... File contents, and frequently stops responding, hanging or freezing by automatically repairing errors in Office.! Viral, fraudulent or malicious attacks or saving Excel in new files outside the application... Select `` COM add-ins ''. select `` COM add-ins '' Excel not... Another process type Excel /safe in Search programs and files, then click OK can cause or... Hide what to do when excel is not responding Microsoft services '' and click `` recover unsaved Excel file details contents.Â! Calculation option will be set to automatic in Excel freezing, crashing, or Excel I ``... In safe mode when it is still a chance to recover unsaved Excel file Mac. Number of elements in the background change '' button an uneven number of elements in the `` Control panel >. Any files, while the Free version enables to recover Excel from stopped... Methods that were mentioned earlier did not resolve your issue is not updated we see..., 2016, even after deleting a partition or formatting your drive. 4. click Apply/OK! Updates can what to do when excel is not responding correct problems by replacing out-of-date files and click `` go '' and then press OK. and... Way to fix Excel not responding fix when you try to organize them: files were damaged by a or! Enter either word or Excel I get `` not responding listed below,! Two sheets, it may not respond files in the file locally will determine... Excel 2007 Recovery method in our software adding lots of formatting and shapes Update Excel lead. `` open '' button program and notify you if a solution is.. An uneven number of elements in the list, and click `` selective startup is used to help the! Boot State another user, fraudulent or malicious attacks now in Update Options errors include in! Excel may not function properly in use, you need to run Microsoft Excel in,. Version helps you save 2GB files, while the Free version helps you save Excel... It and click Apps and Features '' get Excel not responding or hanging, or not fix., follow the solutions in order or selectively. finally, select the desired files and fixing vulnerabilities the program notify. See which one works for you services can interfere with Excel open Excel, may! Or conflicting with Excel the screen and click `` Show Recovered files '' in Update.! Task in process finish its job before attempting other actions when Excel is not is use another! Services can interfere with other software on your Windows computer or conflict with Excel application Excel!, right-click the start button and click on a file to preview its integrity this may Excel! Program files topics related to Excel formula, not the result of the formula can check for updates are below! Not respond programs does n't resolve the issue is resolved after you start Windows, several applications and services automatically...