Microsoft Excel Not Enough Memory Error. In this article, you will learn to know how to fix Microsoft Excel not enough memory error. We will troubleshoot this problem by using various methods. Many users have faced this error. This problem can be because of various factors like:
-User tried to copy a large number of cells.
-User copied different formulas from a large worksheet area of an extremely large worksheet.
Microsoft Excel Not Enough Memory Error Solution:
Not enough memory in Microsoft Excel is caused when the Excel file becomes more than 2 Gb. It also happens when you select more than 32,760 source cells using the smart fill option. Just take precautions, while using Excel to avoid not having enough memory in Excel. If the error is still occurring after using it with precaution, try the methods given below to solve this problem.
Solution 1 – Use Excel With Some Safety Measures:
You can avoid this error by taking some precautionary measures which are as under:
1.Select the cells in smaller parts rather than selecting them all at one time.
2.Break the Excel file into smaller workbooks, if it is too big.
3.Keep the workbook to a limit of 2 GB.
4.Instead of saving workbooks all at once, save them at regular intervals.
By taking these precautionary measures, you can solve the Excel error not enough memory.
Solution 2 – Disable Hardware Graphics Acceleration:
Try to disable the hardware graphics acceleration feature of the Excel application. Many times disabling this feature can solve the problem. To do so, follow the steps below:
1.Open Excel and select the File option.
2.Click on the Options from the menu to open Excel Options console.
3.Click on the Advanced option.
4.Scroll down and locate the Display section.
5.Check the Disable hardware graphics acceleration box.
6.Click OK to save changes.
Solution 3 – Update Microsoft Office:
An outdated and old version of Microsoft can also cause Excel not enough memory error. To update your Microsoft 360, follow the steps given below:
1.Open Microsoft Excel.
2.Select the File option on the upper left corner of your screen.
3.Click on the Account option from the menu.
4.Now, click the Office Updates option.
5.Click on the Update Now option from the drop-down menu.
6.Microsoft Office will now check for available updates and then update automatically.
