XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix:This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:
- DriverFix has been downloaded by 0 readers this month.
If you work in an organization, you most probably have the latest version of the Microsoft Office suite or Office 365 installed on your PC. Even if you don’t, it’s very unlikely that you have never heard of Microsoft Excel before.
However, this doesn’t make Excel immune to occasional bugs. Such would be the case with an error message users have been reporting, which looks something like this: Out of Memory. Not enough System Resources to Display Completely.
How can I fix insufficient memory errors in Excel?
1. Check the contents of the spreadsheet
These are the main things that cause the out of memory error messages:
- Inserting a row or column
- Performing calculations
- Copy and pasting
- Sorting
- Opening or closing the workbook
- Running VBA
If you are doing any of the actions mentioned above and you receive the error, check what exactly is wrong. If that is the case, try doing the following:
- Recheck the formulas
- Recheck the calculations
- Avoid using excess shapes
- Avoid using complex PivotTables
- Try not to use macros and complex charts with many data points
2. Check your Excel Add-ins
If you think an Excel add-in is responsible for an error, try disabling it and then check if the error appears again.
- Click File
- Go to Options
- Select Add-ins
- Click the Go button
- Select the add-ins you want to disable or remove
- Uncheck the box in front of the respective add-in
- Click OK
3. Verify Excel or install the latest updates
Depending on whether your copy of Office is Click-to-run or MSI-based install, the next steps will vary a little.
3.1. Click-to-run
A window called How would you like to repair your Office Programs will appear
- The Quick Repair option is faster but it only detects and then replaces corrupted files
3.2. MSI-based
4. Disable your Antivirus
Antivirus software will usually run in the background scanning your Excel file as you make it. This will usually make Excel run out of memory and thus trigger the error message.
Disable your antivirus program and see if Excel still encounters this error. Remember that each antivirus program is disabled in a different way, so check the documentation on the developer’s website for more info.
If you’re looking for a new antivirus, we have the one for you!
5. Change your default Printer
6. Use the 64-bit version of Excel
The 32-bit version of Microsoft Excel has a is 2 GB limitation. So, if the processes require more than 2 GB, Microsoft excel will run out of memory and the error message will appear.
Moving to the Microsoft Excel 64-bit version provides more space and will thus solve any memory-related issues you may have with the application.
If you’re tired of not enough RAM, check out our top recommended upgrade options!
7. Completely reinstall Microsoft Excel
Sometimes we have no choice but to start from scratch. Such would be the case if all the above-mentioned solutions fail to solve your problem.
Did our guide help you in getting rid of the memory-related error in Excel? Let us know in the comments section below.
RELATED ARTICLES YOU SHOULD CHECK OUT:
ncG1vNJzZmivmaOxsMPSq5ypp6Kpe6S7zGicsZuVoXqqutKunZ%2Bhk56yr8CMppymp6KufA%3D%3D