Are you facing “Excel out of memory, not enough resources to display completely” error message when you are trying to modify an excel work sheet on your computer? There is no need to worry further, as this problem usually happens when you are trying to modify a large excel worksheet which contains a huge number of calculations. Simply follow the fixes prescribed in this article, and the problem will be solved in no time. But before moving ahead to the main solutions, don’t forget to go through the workarounds to perform some tests over the problem.
1. First, you have to check if this problem is happening in a specific work sheet or in every other worksheet. Simply, open and try to modify any other worksheet ( like adding an additional column/ row in the worksheet).
2. If this is the first time this type of problem is happening on your computer, restarting your computer may help you out.
3. Disable antivirus on your computer and then check if the error occurs or not.
If the problem precedes after rebooting your system, follow these solutions.
Fix-1 Check the contents of the spreadsheet-
1. Open Excel worksheet on your computer. After opening the worksheet, check these following parameters-
a. Recheck all the formulas you have used in Excel worksheet.
b. Recheck all the calculations in the worksheet
c. Check if the worksheet contains any unnecessary shapes or charts.
d. Try to reduce the number of charts and the charts with huge number of data points.
If you have done this and still the error persists, go for the next fix.
Fix-2 Remove unnecessary add-ins from Excel-
Sometimes the add-ins of Excel may cause this problem at your end. In order to disable unnecessary Excel add-ins, simply follow this steps-
1. Open Excel worksheet where you are facing the problem.
Click on the Search box beside Windows icon and type “Excel“, click on “Excel” to open Excel on your computer.
2. In Excel window, click on “File” in the menu bar. Now, scroll down and on the left hand side of the same window, click on “Options“.
3. In Excel Options window, click on “Add-ins” on the left hand side of the window.
4. You will notice the list of add-ins on the right side of the same window. Click on “Go” on the right side of the window.
5. In Add-ins window, uncheck the add-in which seems unnecessary to you (which you don’t use that much).
6. Finally, click on “OK” to save the changes.
Relaunch Excel window on your computer to let the changes take effect. Check if you are still facing the same issue or not.
Fix-3 Repair Excel-
Repairing MS-office application may solve this issue on your computer.
1. Press Windows key+R to launch Run, and then type “appwiz.cpl” and hit Enter.
Program and Features windows will be opened.
2. In Program and Features window, scroll down to find and right click on “Microsoft Office Professional Plus” and then click on “Change“.
Click on “Yes” if you are prompted by User Account Control asking for permission to make the changes.
3. When you will be asked ‘How would you like to repair your Office programs?‘ click on “Quick Repair” and then click on “Repair” to start the repairing process on your computer.
Once the repair is done, you may need to restart your computer to witness the changes. After rebooting, open the excel sheet again on your computer.
Your problem should be solved.
Fix- 4 Set your printer as default-
Some users are claiming to solve the problem as they have set the printer as their default printing device.
1. Type “Printers & scanners” in the search box beside the Windows icon. Click on the “Printers & scanners“.
2. Now, on the right pane you will see the list of printers & scanners. Uncheck the box beside “Let Windows manage my default printer” option.
3. Now, from the list of the printers click on the printer which you are using.
4. After doing that, click on “Manage“.
5. Click on “Set as default” in the Manage your device settings window.
Reboot your computer.
After rebooting your computer, Excel should work flawlessly.
1. This error happens mainly due to excessive load on your computer, caused by complex excel files with loads of charts, tables etc. You may need to increase the physical memory (RAM) of your computer.
2. Check if any update is pending for Windows 10.
Sambit is a Mechanical Engineer By qualification who loves to write about Windows 10 and solutions to weirdest possible problems.