Not Enough Memory to Run Microsoft Excel Please Close Other Applications and Try Again
Summary :
Microsoft Office is world-famous assistance for piece of work. Information technology includes many applied programs, such as Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Even Microsoft Outlook is available as a office of the Microsoft Role suite.
However, people complained they meet the error message: At that place is not plenty retention or disk infinite and don't know what to do.
Quick Navigation :
- Message Saying There Is Non Enough Retentiveness or Disk Infinite
- Causes for Bereft Memory or Disk Space
- Gear up There Is Not Enough Retentiveness or Disk Infinite Fault
- Determination
- In that location Is Not Enough Memory or Deejay Space FAQ
- User Comments
Message Saying There Is Not Plenty Retentivity or Disk Space
3 of the about frequently used Microsoft programs are definitely: Microsoft Word (used to deal with give-and-take data), Microsoft Excel (used to organize and collect data in tabular class), and Microsoft PowerPoint (a useful tool for making a presentation). When you are trying to open the programs or perform an activity in them, you may probably cease up in failure; a prompt window will bear witness upwardly to prevent you from continuing what you are doing: In that location is non enough retentiveness or disk infinite.
Then what does the insufficient memory or deejay space mistake mean? What causes this error to occur? How to fix in that location is insufficient memory Give-and-take or Excel? In the following content, I will answer these questions one past 1.
MiniTool Solution is a software development company with a high reputation and it can assist you solve almost every problem yous tin can think of most figurer, disk, and data.
The fault bulletin: At that place is insufficient disk space to consummate operation may appear when you are copying files/folders. How to prepare it properly?
Many people ask for assistance since the Excel or Give-and-take has bereft memory; you can browse the examples in Microsoft Community and other forums.
Causes for Insufficient Memory or Disk Space
Many people reported they see the bereft memory or disk space when opening Discussion 2016 Give-and-take. Till now, the not enough disk space problem is confirmed to bear witness up on Office 2010, Office 2013 and Function 2016.
Our team made a report on the cause of this problem subsequently investigating diverse users' reports and detect some common factors to trigger the problem in Microsoft Word and Microsoft Excel.
Microsoft Word 2016 Insufficient Memory or Disk Space
- Ane: the Normal.dotm file is corrupted.
- Two: the font cache is corrupted.
- 3: the permissions on the font folder are non enough.
- Four: the Office installation is broken.
- Five: an Add-in has problem.
One: the Normal.dotm file is corrupted.
In general, the default font styles will exist loaded automatically while you're opening Discussion. Even so, if the Normal.dotm file is damaged somehow, this process tin't be completed; and then, the insufficient memory mistake will get thrown.
The easy way to fix the problem under such circumstances is forcing Windows to create a new .dotm file.
How to fix corrupted files?
Ii: the font cache is corrupted.
Equally mentioned in the previous cause, the font styles are loaded by default when opening Microsoft Office utilities. In fact, they are stored as cache in a font binder on Windows. Sometimes, the font folder may get damaged; then, you'll receive the not plenty memory/disk space error because the fonts used by the file yous're trying to open are included in that corrupted folder.
The like shooting fish in a barrel way to eliminate the error is creating a .bat file that is capable of refreshing your font cache.
3: the permissions on the font binder are not enough.
Similarly, if users don't take the necessary permissions to admission the corresponding font binder, they won't exist able to open the file.
In this case, you lot must gain enough permission before opening it by:
- Creating a new policy through Registry Editor
- Making use of a series of Powershell commands
You Need Permission To Perform This Action: Solved.
Four: the Part installation is broken.
The fault message will appear on your PC screen whether the install of Microsoft Office is incomplete or crippled (this may result from an AV browse).
If this is the root reason for causing the error, you should solve it by invoking Programs and Features to repair the Function installation.
Five: an Add-in has trouble.
If whatever errors occurred on an Add together-in, the Microsoft Give-and-take insufficient memory will be caused. Till now, several Give-and-take Add together-ins are found to be responsible for the problem.
If this is the situation, you need to piece of work things out by identifying the problematic Add-in and remove information technology from your list.
Error Messages Indicating Word Not Enough Memory or Deejay Space
You may run across the following messages in Word when it runs out of infinite:
- There is non enough memory or disk space to run Give-and-take.
- In that location is not enough memory or disk space to update the display.
- At that place is not enough memory or deejay space to consummate the functioning.
- There is not enough memory or disk space to run the grammar checker.
- There is not plenty memory or disk space to display or print the motion-picture show.
- In that location is not enough memory or deejay infinite to repaginate or print this document.
- There is bereft memory or disk space. Give-and-take cannot brandish the requested font.
- …
Excel Insufficient Disk Space
The mistake occurs frequently when users try to copy a large book of data in the Excel sheets or add formulas to a very large worksheet area.
What'southward the root reason for causing this? Information technology's really the limitations built in Microsoft Excel.
- The memory of each Excel's instance can't be more than 2 GB (gigabyte).
- The source cells number should be less than 32,760 when y'all're using a smart fill option.
- The maximum number of line feeds per cell is 253.
- The total number of rows and columns on a worksheet can't be more than 1,048,576 and 16,384.
- A cell can't contain characters more than than 32,767. While the characters in a header or footer should be less than 255.
You lot may run into the following messages that bespeak this error in Excel:
- Not enough system resources to display completely.
- There is non enough disk space. Complimentary enough disk space, then endeavor again.
- Not enough memory to run Microsoft Excel. Delight close other applications and effort once more.
- Excel cannot complete this job with available resources. Choose less data or close other applications.
- There isn't enough retentivity to complete this activeness. Try using less data or closing other applications. To increase memory availability, consider using a 64-bit version of Microsoft Excel or adding memory to your device.
- Microsoft Excel cannot open or save any more documents because there is not enough available retention or disk space. To make more than retentiveness available, close workbooks or programs you no longer need. To free deejay space, delete files you no longer need from the disk you are saving to.
This role shows you the popular causes of At that place is not plenty memory or disk space in both Microsoft Word and Microsoft Excel. Besides, the possible error messages you may come across are as well displayed clearly. Click to tweet
Fix There Is Non Enough Retentivity or Deejay Space Fault
Outset, please make sure your estimator has enough retentivity or free deejay infinite left. If non, yous should delete unnecessary files and folders from the hard disk drive.
How to free up disk space:
- Delete data direct (call up deleted files on PC).
- Utilise Diskpart (recover data lost past DiskPart Clean).
- Use Control Prompt (recover files using CMD).
- Turn to Disk Cleanup (Disk Cleanup empty your Downloads folder).
- …
How to recover files lost when yous are trying to go more retention and complimentary disk space? Definitely, you demand MiniTool Power Data Recovery, which enjoys a very good reputation in the manufacture.
Here'southward a file recovery tutorial you should follow.
Step one: download the setup program of MiniTool Ability Data Recovery; don't save information technology to your drive containing lost files you lot program to recover.
Free Download
Step two: run the setup program to end software installation and launch information technology at the terminate of the procedure.
Footstep three: go onLogical Drives selected if the drive contains lost files still exist. Otherwise, you lot should shift to theDevices tab.
Step four: determine which partition contains the missing files; and so, double click on it to start a full browse.
Stride five: more and more than files will exist institute while the browse is processing. Delight browse the plant items carefully and select the data you actually want. (You should look till the stop of the scan to see the all-time recovery result.)
Pace six: click on the Salve button located in the bottom correct corner. Then, choose a storage path for the files you take selected in the previous step and click on the OK push button to confirm.
Now, you should await for the recovery procedure to consummate automatically.
FYI: what if your hard disk drive is corrupted and you can't kicking PC successfully? Please read this folio to know how to recover data:
In the following content, I volition provide other useful means to fix the mistake in both Word and Excel when it is caused by other problems.
There Is Bereft Memory Give-and-take
- Prepare i: rename Normal.dotm file.
- Set 2: rebuild the font enshroud.
- Fix three: proceeds necessary permissions.
- Fix 4: repair the Microsoft Office installation.
- Fix 5: remove the Add-ins.
Fix 1: rename Normal.dotm file.
The activity of renaming the Normal.dotm file will forcefulness Microsoft Word to create a new file when yous launch the program the next fourth dimension; thus, the problem could be solved if it's caused by a corrupted Normal.dotm file.
- Open Windows Explorer. (How to fix when Windows Explorer has a problem?)
- Open up Local Disk (C:).
- Observe and open the Users folder.
- Look for the folder with your username. And then, open it.
- Navigate to the AppData binder (which is not visible by default).
- Open Roaming, Microsoft, and Templates in older.
- Click View from the menu bar.
- Check File proper noun extensions in the Testify/hide surface area.
- Right click on the dotm file.
- Choose Rename.
- Add .old subsequently Normal.dotm and printing Enter.
- Choose Aye to confirm the change.
If you can't run across the AppData folder, please read the How to fix when you tin can't detect the AppData folder part in this postal service carefully.
Tip: You tin also try to fix the error by deleting the Normal Template.
Set up ii: rebuild the font cache.
- Open up upwards a Run dialog box by pressing Start +R or through other means.
- Blazon notepad and hit Enter.
- Copy & paste the content listed below.
- Click on the X button and choose Save in the pop-up window.
- Give it a name with the extension of .bat.
- Click Save.
- Right click on the .bat file and choose Run as administrator.
- Wait for the process to complete.
Fix three: gain necessary permissions.
- Open Run dialog.
- Type powershell and press Ctrl + Shift + Enter.
- Type Go-acl C:\Windows\fonts\arial.ttf | Set up-Acl -path c:\windows\fonts\*.* and hit Enter.
- Blazon Get-acl C:\Windows\fonts\arial.ttf | Set-Acl -path c:\windows\fonts and hitting Enter.
- Look for the commands to finish.
Gear up 4: repair the Microsoft Office installation.
- Open up upwards a Run dialog box by pressing Kickoff +R or through other means.
- Typecpl and click OK.
- Look for Microsoft Office from the list in Programs and Features window.
- Right click on Microsoft Part and choose Change.
- Choose Yes if in that location'southward a User Account Control window appears.
- Bank check Quick Repair nether How would y'all similar to repair your Office programs.
- Click on the Repair button at the bottom and click Repair over again in the confirmation window.
- Wait for the procedure to complete.
Fix 5: remove the Add-ins.
- Open the problematic program.
- Go to File > Options.
- Select Add together-ins from the left-hand side of Word Options.
- Select Word Add-ins after Manage from the right panel and click Go.
- Uncheck all the options related to Add-in and click OK.
- Repeat step 2.
- Select COM Add-ins from the dropdown list of Manage and click Get.
- Echo step 5.
- Close the programme and open the Word file which triggered the previously.
- If the error doesn't appear, please bank check the options y'all unchecked in stride 5 and step viii.
Once yous can confirm which Add-in causes the mistake, you should select it in the Add-in carte du jour and click Remove.
Other fixes:
- Turn off the Automatic Spelling Checking and Grammer Bank check.
- Reset the Registry Entries of Word.
- Run Microsoft Fix-It or Troubleshooting.
- Create SaveZoneInformation policy in Registry Editor.
How to recover a Word document easily?
There Is Bereft Retention Excel
- Prepare ane: select cells gradually.
- Prepare 2: update drivers & disable hardware graphics acceleration.
- Ready three: divide an Excel file into different workbooks.
- Fix four: set to manage paging file size automatically.
Prepare 1: select cells gradually.
- Please do the same for the post-obit department of cells when y'all choose only part of the entire range yous demand to exist filled.
- To make sure you won't accomplish the limit, please select the last row of the previously filled section when y'all move on to the latter segments (the 2d, third, etc.).
- But echo this process to reach the terminate of the choice needed.
Fix 2.
Pace i: update drivers.
- Open Microsoft Excel.
- Select File, Account, and Part Update 1 after another.
- Click Update Now.
- Wait for information technology to consummate.
Step two: disable hardware graphics dispatch.
- Click File, Options, and Advanced.
- Look for Display area from the right panel.
- Uncheck Disable hardware graphics dispatch.
- Click OK.
Ready 3: divide an Excel file into different workbooks.
Information technology's a good option to split your big Excel files into a few workbooks and and then open them in different instances of Excel. This reduces the possibility of getting the error caused by reaching the 2GB limitation for a single workbook.
Fix four: set to manage paging file size automatically.
- Open Control Panel.
- Select System and Security.
- Click System.
- Select Avant-garde organisation settings from the left sidebar.
- Keep Advanced tab selected. Click Settings under the Performance area.
- Shift to Advanced tab.
- Click Alter… under the Virtual retentiveness area.
- Check Automatically manage paging file size for all drives.
- Click on the OK button in all Windows to confirm changes.
This office shows yous how to solve the bereft retentivity or deejay infinite error after it appeared in Microsoft Discussion/Excel. Meanwhile, it introduces a powerful recovery tool that you can use to recover files lost due to all common reasons. Click to tweet
Conclusion
Undoubtedly, In that location is not enough memory or disk space is a common error on Windows. You may probably run across it when opening Word/Excel or other Role programs. The error will as well occur suddenly when y'all're performing actions in the programs.
In the previous parts, I have covered the possible reasons for leading to the mistake. Then, I have provided several solutions for fixing information technology yourself. Please read the above content carefully to solve your trouble.
In that location Is Non Enough Memory or Deejay Infinite FAQ
What does deejay space mean?
Disk space, which is also known as deejay storage, storage capacity, or hard drive capacity, refers to the maximum amount of files that a disk or drive can keep. Everything you installed on the computer will accept up some disk space: operating organisation, applications, and personal data.
What does information technology mean when it says at that place is not plenty disk space?
If yous're receiving an error message saying that your reckoner doesn't have enough deejay space, it ways that there is little free space left on your hard drive. Another unusual reason for causing this is that your hard bulldoze runs into problem and needs to be fixed.
What does information technology mean when Excel says at that place is not enough disk space?
If y'all run into the error bulletin at that place is not enough available memory or deejay space in Excel, information technology means you can't open up the Excel or save more than documents. What yous should do at this time is: closing the workbooks or programs you don't need anymore.
How exercise I bank check my deejay space?
- Open File Explorer and await at the Devices and drives section.
- Open Disk Management and look at the chapters & free space of each bulldoze.
- Open Settings -> cull Organization -> go to Storage choice -> wait at the Storage layout.
Source: https://www.minitool.com/data-recovery/there-is-not-enough-memory-or-disk-space-word.html