Most Excel users have experienced the problem of Microsoft Excel Not responding, freezing, getting stuck or crashing. You will find below the steps to fix Microsoft Excel not responding issue.
Microsoft Excel Not Responding
Introduced way back in 1985, Microsoft Excel has grown into one of the most popular, powerful and indispensable computer programs, used by workplaces all over the world.
Apr 23, 2020 Converting FAT32 to NTFS should be the most ideal way to fix 'not enough disk space on flash drive', for it keeps your data intact. For many times we have explained their differences, thus we are not going to repeat. You can read NTFS vs. ExFAT – Differences and How to Format to for more information.
Feb 14, 2013 When i try and run a simple sort command on my mac using excel i get 'not enough memory' - i have just - Answered by a verified Microsoft Office Technician We use cookies to give you the best possible experience on our website.
However, Microsoft Excel can sometimes freeze up, stop working or even crash while working on large or complex spreadsheets.
Excel 2008 For Mac Keeps Saying Not Enough Memory Available
On such frustrating occasions, you may see an error message reading “Excel is not responding”, or “Excel has stopped working.”
We are providing below a number of methods that can fix the issue of Microsoft Excel not responding on your computer.
Aug 31, 2020 Thus, your computer may have enough space in its local memory but excel will show “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space”. Jan 10, 2018 You’ll always want at least 10% disk space available for the OS and memory swapping tasks, but 15% is a better number if you can manage it. With a 500GB drive that means I’d need to keep 50-75GB free if possible. The less available space you have, the more you’re stressing the memory manager and disk manager and can see some performance.
1. Repair Microsoft Office
The problem of Microsoft Excel not responding might be due damaged or corrupted program files. This can be fixed by using the Repair option as available on your Windows computer.
1. Right-click on the Start button and click on Run.
2. In the Run Command Window, type appwiz.cpl and click on OK.
3. On the next screen, right-click on Microsoft Office and click on the Repair option.
Note: If the Repair option is not available, right-click on Change > select Repair in the pop-up and click on Continue.
Wait for the repair program to repair the Microsoft Office program.
2. Change Default Printer
Microsoft Excel can become unresponsive if it is unable to communicate with the default printer on your computer.
This can be fixed by temporarily switching the default printer on your computer to Microsoft XPS Document Writer.
1. Open Settings > click on Printers & Scanners.
2. On the next screen, click on Printers & Scanners in the left pane. In the right-pane, click on Microsoft XPS Document Writer and click on Manage.
3. On the next screen, click on Set as Default option.
After setting Microsoft XPS Document Writer as the default printer, open Microsoft Excel and see if it is now working properly on your computer.
3. Run Excel in Safe Mode
This method can help if the problem is being caused by a Plug-in or an Add-on program.
1. Right-click on Start button and click on Run.
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 click on OK to start Microsoft Excel in Safe Mode.
3. Now try opening the particular Non responsive Excel File again.
If this method helps in fixing the problem, you can follow the next method as provided below to disable the Add-in programs on your computer.
4. Disable Add-Ins & Plug-ins
Follow the steps below to disable Plug-ins and Add-in programs.
Excel Not Enough Memory Mac
1. Right-click on Start button and click on Run.
2. In the Run Command Window, type excel.exe /safe and click on OK to start Microsoft Excel in Safe Mode on your computer.
3. Once you are in Microsoft Excel, click on the File tab in top menu bar > scroll down and click on Options.
Note: In older versions of Excel, click on File Icon > Excel Options button
4. On the next screen, click on the Add-ins in the left pane. In the right-pane, select Excel Add-ins and click on the Go… button.
5. On the Add-Ins screen, uncheck the little box next to the active Add-Ins and click on OK to save.
After disabling Add-Ins, restart Microsoft Excel and see if the problem of Microsoft Excel Not Responding is now fixed.
In case the problem is fixed, try to isolate the particular Add-in that is causing problems by disabling the Add-Ins one by one.
Particular Microsoft Excel File Not Responding
In this case, the problem appears to be confined to a particular Spreadsheet and the Excel Program itself is working fine.
In many cases, this problem can be fixed by clearing conditional Formatting from the spreadsheet.
Mac Excel Not Enough Memory Error
1. Open the Excel File that is getting stuck on your computer.
2. On you are in the file, click on Home > Conditional Formatting > Clear Rules > Clear Rules From Entire Sheet.
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. 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, it confirms that the file is getting stuck due to conditional Formatting.
The next step would be to narrow down the problem to a particular sheet or section of the File and apply corrections as required