MS Excel is a widely used application but there are many cases seen when the users face issues and errors while working on the Excel spreadsheet. The one common MS Excel error is:
“Not enough system resources to display completely”
Hi, I’ve been working with links the past few days and have been experiencing the subject error message. What do I need to do to avoid the error?
Thank you in advance…
Original post from MrExcel Forums…
What Errors Occurs When Excel Ran Out Of Resources?
Well, Excel ran out of resources error is common among the Excel users and it displays in many different ways to the users, such as:
1. Out of Memory
2. Not enough System Resources to Display Completely
3. There isn’t enough memory to complete this action. Try using less data or closing other applications. To increase memory availability, consider:
Using a 64-bit version of Microsoft Excel. Adding memory to your device.
All these errors are related to memory and can be very generic. Identifying the real cause of the issue is quite complicated. Moreover, if your file size is bigger it contains a large number of features, then you can possibly having low available memory resources.
So it is very important to know the Excel specification and limitation as per the version you are using.
Recommended Solution: For Not Enough System Resources To Display Completely Error
Now to fix the “Excel not enough system resources to display completely”, you can make use of the trusted and professional recommended MS Excel Repair Tool. This is an advanced repair utility and is designed with an easy-to-use algorithm so that novice users can use it with ease.
With this, you can fix various Excel errors, repair corrupted, damaged Excel workbooks. It also helps you to recover lost, deleted data in the preferred location without any modification. So, apply this tool once and make your Excel file error-free without doing anything manually.
Nevertheless, there are some alternate solutions as well that you can use to fix not enough resources Excel error.
Steps to Utilize MS Excel Repair Tool:
How To Fix “Excel Not Enough System Resources To Display Completely” Error?
Although there is no exact solution that you can use to fix available resources or not enough resources Excel error, you can try a few possible solutions and make your Excel error-free. Try the given solutions one by one and if it did not help then simply go to another solution from the list:
Solution 1: Check Contents Of The Spreadsheet
The very first thing you need to verify is whether the error is specific to one workbook or others created from the same template. Things that cause the out of memory error messages are:
- Inserting a row or column
- Performing calculations
- Copy and pasting
- Opening or closing the workbook
- Running VBA
If while performing any of the above actions, you are getting the error, then check what is going wrong in your file. Recheck the formulas, calculations, avoid using excess shapes, complex PivotTables, macros and complex charts with many data points.
Also if you are using the Shared Workbook features then this might be the reason for getting the not enough resources Excel error. Cleaning out the Custom Views will help you to fix the available memory issues.
Steps to do this:
- Click on the Excel ribbon and hit the View tab.
- Then from the Custom Views on the dialog box choose the Delete button.
Well, deleting the Custom Views does not delete anything in the Excel spreadsheet, this will delete the print areas and filters and these can be easily reapplied.
Solution 2: Verify Add-ins Interference
It might happen the add-ins you are running cause the error so try disabling them to fix allow Excel to work properly and fix the not available resources error.
Follow the steps to disable add-in:
- Click File > Options > Add-ins.
- Then at the bottom of the window near Manage > click the Go button.
- And select the add-ins you want to disable or remove.
- Now to disable the add-in just uncheck the box in front of its name. And to uninstall the add-in select it > click Remove.
- Click OK for saving the changes and go to the document.
And if after removing the add-ins the error is resolved then contact the manufacturer of the add-in for support.
Solution 3: Verify/Install The Latest Updates
Well, as I always said it is very important to update your Windows system with the latest updates. So, make sure to install the important and optional updates, these can and fix the issues and errors by replacing the outdated files and fix vulnerabilities.
For installing the latest Office updates, go to the Microsoft official website and check for the updates specific to your Windows version.
Solution 4: Use Different Default Printer
When you start Excel it uses the default printer to help the users to render the file. Try testing with “Microsoft XPS Document Writer” as the default printer and check if the Excel ran out of resources “available resources” error is fixed.
Follow the steps:
- Close Excel > and open the printer and faxes Window (XP) or Devices and Printers (Vista, 7, 8, 10)
- And right-click the “Microsoft XPS Document Writer” printer
- Click Set as Default
Hope this helps you to resolve the error, if not then try another solution.
Solution 5: Disable Antivirus
Antivirus in some cases causes the issue by scanning the Excel file or other data in the file. In many cases the Excel ran out of memory error is random and found with any spreadsheet.
So check whether the antivirus program is conflicting with the program, to test this temporarily disable the antivirus program and restart the Excel file. Now check if the error message is prompted or not.
However, if the issue is not resolved after disabling then turn on the antivirus program and follow the solution 6.
Solution 6: Use 64 Bit Version Of Excel
The common reason for getting the Excel not enough system resources to display completely is running the large Excel files, and this uses the memory available in 32 bit Excel application.
In the 32 bit application, there is a 2 GB limitation. So, if the processes require more than 2 GB, then move to the Microsoft Excel 64-bit version. This provides more space and it is estimated the not enough system resources to display completely error is resolved now.
Solution 7: Try Disabling Preview/Details Pane (For Windows 7 Users)
This solution is particularly for Windows 7 users; here you need to disable the preview and details panes in Windows.
Here follow the locations where you need to disable them.
In Windows Explorer:
- Right-click on the Start button > click open Windows Explorer.
- And click Organize > Layout.
- Uncheck Details Pane and Preview Pane.
- Click File > Open.
- And click Organize > then Layout.
- Uncheck Details Pane and Preview Pane.
- First, open a new e-mail.
- Then in the “Include” group on the Ribbon > click Attach File.
- After that click Organize > Layout.
- And uncheck Details Pane and Preview Pane.
If after following the entire above given solutions then the only option left is to perform a clean install.
Solution 8: Perform A Clean Installation
Is the error message appears sometimes after rebooting or shutting down some of the applications? Then it might happen the other applications are consuming the system memory and not enough resource is allocated to Excel.
Then close the extra applications running on the system
Moreover, if there is any other issue is causing the Excel error not enough system resources error then perform a clean boot in Windows and reinstall the applications
So, this is all about Excel not enough system resources to display completely error. Try the given solutions one by one and resolve the Excel ran out of memory error.
I tried my best to provide the entire possible solutions that work in your case to fix the Excel ran out of resources error.
You can make use of the MS Excel Repair Tool, to fix Excel errors and even optimize the Excel performance.
Additionally, if you are having any additional questions concerning the ones presented, do tell us in the comments section below or you can also visit our Repair MS Excel blog section.