Not Enough Memory to Run Microsoft Excel. Please Close Other Applications and Try Again

Summary :

Microsoft Part is globe-famous aid for piece of work. It includes many applied programs, such as Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Even Microsoft Outlook is available as a office of the Microsoft Office suite.

However, people complained they encounter the error message: There is not enough memory or disk space and don't know what to exercise.

Quick Navigation :

• Message Saying In that location Is Non Enough Memory or Disk Space
• Causes for Insufficient Retentiveness or Deejay Space
• Gear up There Is Non Plenty Memory or Deejay Space Fault
• Conclusion
• There Is Not Enough Memory or Deejay Space FAQ
• User Comments

Bulletin Maxim At that place Is Not Enough Retention or Disk Infinite

Three of the most frequently used Microsoft programs are definitely: Microsoft Word (used to deal with word information), Microsoft Excel (used to organize and collect data in tabular form), and Microsoft PowerPoint (a useful tool for making a presentation). When you are trying to open the programs or perform an action in them, you may probably end upwards in failure; a prompt window volition prove up to forbid you lot from continuing what you are doing: There is non enough memory or deejay space.

Then what does the insufficient retention or deejay infinite error mean? What causes this error to occur? How to fix there is insufficient retentivity Word or Excel? In the following content, I volition reply these questions ane by one.

MiniTool Solution is a software development company with a loftier reputation and information technology can assistance you solve nearly every problem you tin can think of about figurer, disk, and data.

The fault bulletin: There is insufficient disk space to complete performance may appear when yous are copying files/folders. How to fix it properly?

Many people enquire for help since the Excel or Word has bereft memory; you can browse the examples in Microsoft Customs and other forums.

Causes for Bereft Retention or Disk Space

Many people reported they see the insufficient retentivity or disk space when opening Word 2016 Give-and-take. Till now, the not plenty deejay space trouble is confirmed to show upward on Office 2010, Office 2013 and Office 2016.

Our team made a study on the cause of this trouble after investigating various users' reports and notice some common factors to trigger the problem in Microsoft Word and Microsoft Excel.

Microsoft Word 2016 Insufficient Retentivity or Deejay Space

1. One: the Normal.dotm file is corrupted.
2. Two: the font enshroud is corrupted.
3. Three: the permissions on the font folder are non enough.
4. Four: the Office installation is broken.
5. Five: an Add-in has problem.

1: the Normal.dotm file is corrupted.

In general, the default font styles volition be loaded automatically while you're opening Word. However, if the Normal.dotm file is damaged somehow, this procedure can't be completed; then, the insufficient memory error will get thrown.

The easy way to ready the problem under such circumstances is forcing Windows to create a new .dotm file.

How to ready corrupted files?

Ii: the font cache is corrupted.

Every bit mentioned in the previous cause, the font styles are loaded past default when opening Microsoft Office utilities. In fact, they are stored as cache in a font folder on Windows. Sometimes, the font binder may get damaged; then, you'll receive the non plenty memory/disk space fault considering the fonts used by the file you're trying to open are included in that corrupted folder.

The easy mode to eliminate the mistake is creating a .bat file that is capable of refreshing your font cache.

Three: the permissions on the font folder are not enough.

Similarly, if users don't have the necessary permissions to admission the respective font binder, they won't exist able to open the file.

In this case, you must proceeds plenty permission before opening information technology by:

• Creating a new policy through Registry Editor
• Making use of a series of Powershell commands

You lot Need Permission To Perform This Activeness: Solved.

Four: the Function installation is cleaved.

The error message will appear on your PC screen whether the install of Microsoft Part is incomplete or bedridden (this may outcome from an AV scan).

If this is the root reason for causing the error, you should solve it by invoking Programs and Features to repair the Office installation.

Five: an Add together-in has problem.

If whatsoever errors occurred on an Add-in, the Microsoft Word insufficient memory volition be caused. Till at present, several Word Add-ins are plant to be responsible for the problem.

If this is the situation, you need to work things out by identifying the problematic Add-in and remove information technology from your listing.

Error Letters Indicating Give-and-take Non Enough Retentivity or Deejay Infinite

You may run into the following messages in Word when it runs out of space:

• At that place is not enough memory or disk space to run Word.
• There is not enough memory or deejay space to update the display.
• There is not enough memory or disk space to complete the operation.
• There is non plenty memory or disk infinite to run the grammar checker.
• There is not enough retentivity or disk space to display or impress the moving picture.
• In that location is non enough retentiveness or deejay infinite to repaginate or print this document.
• There is insufficient memory or disk space. Give-and-take cannot display the requested font.
• …

Excel Bereft Deejay Space

The error occurs frequently when users try to copy a large volume of data in the Excel sheets or add formulas to a very large worksheet area.

What's the root reason for causing this? It's actually 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 yous're using a smart fill option.
• The maximum number of line feeds per jail cell is 253.
• The total number of rows and columns on a worksheet can't be more than than 1,048,576 and 16,384.
• A prison 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 indicate this fault in Excel:

• Not enough system resource to display completely.
• There is non enough disk space. Free plenty disk space, and so try once again.
• Not enough retentivity to run Microsoft Excel. Please close other applications and try again.
• Excel cannot complete this task with available resources. Choose less information or close other applications.
• There isn't enough memory to complete this action. Endeavor using less data or closing other applications. To increase memory availability, consider using a 64-chip version of Microsoft Excel or adding memory to your device.
• Microsoft Excel cannot open or save any more documents considering at that place is non enough available memory or disk space. To make more than memory bachelor, close workbooks or programs you no longer need. To gratis deejay space, delete files you no longer need from the disk you are saving to.

This function shows you lot the popular causes of There is not plenty memory or deejay space in both Microsoft Discussion and Microsoft Excel. Also, the possible error messages you may see are also displayed clearly. Click to tweet

Gear up In that location Is Non Enough Memory or Disk Space Mistake

Commencement, please make sure your computer has enough memory or free deejay space left. If not, you lot should delete unnecessary files and folders from the difficult deejay.

How to free upwards disk space:

• Delete data directly (think deleted files on PC).
• Use Diskpart (recover data lost by DiskPart Make clean).
• Use Command Prompt (recover files using CMD).
• Turn to Disk Cleanup (Disk Cleanup empty your Downloads binder).
• …

How to recover files lost when you are trying to get more than memory and gratis disk space? Definitely, you need MiniTool Power Data Recovery, which enjoys a very good reputation in the industry.

Here's a file recovery tutorial you should follow.

Step 1: download the setup program of MiniTool Power Data Recovery; don't salve it to your drive containing lost files you lot plan to recover.

Free Download

Step two: run the setup program to stop software installation and launch it at the end of the process.

Step 3: go alongLogical Drives selected if the drive contains lost files yet exist. Otherwise, you lot should shift to theDevices tab.

Footstep 4: determine which segmentation contains the missing files; then, double click on it to start a full browse.

Footstep five: more and more files will exist found while the scan is processing. Delight browse the establish items carefully and select the data y'all really want. (You should wait till the end of the scan to see the all-time recovery result.)

Pace six: click on the Save push button located in the bottom correct corner. And so, choose a storage path for the files you have selected in the previous step and click on the OK button to ostend.

At present, you should wait for the recovery process to complete automatically.

FYI: what if your hd is corrupted and you tin't boot PC successfully? Delight read this page to know how to recover information:

In the following content, I will provide other useful ways to fix the mistake in both Word and Excel when it is caused past other problems.

In that location Is Insufficient Retention Discussion

1. Fix 1: rename Normal.dotm file.
2. Fix 2: rebuild the font cache.
3. Fix 3: gain necessary permissions.
4. Fix iv: repair the Microsoft Office installation.
5. Prepare 5: remove the Add-ins.

Fix 1: rename Normal.dotm file.

The action of renaming the Normal.dotm file will force Microsoft Word to create a new file when you lot launch the program the next fourth dimension; thus, the trouble could exist solved if information technology's caused by a corrupted Normal.dotm file.

1. Open up Windows Explorer. (How to fix when Windows Explorer has a problem?)
2. Open Local Disk (C:).
3. Find and open the Users folder.
4. Look for the folder with your username. Then, open it.
5. Navigate to the AppData folder (which is non visible by default).
6. Open Roaming, Microsoft, and Templates in older.
7. Click View from the menu bar.
8. Cheque File proper noun extensions in the Show/hide area.
9. Correct click on the dotm file.
10. Choose Rename.
11. Add .onetime after Normal.dotm and press Enter.
12. Choose Yep to ostend the change.

If you can't see the AppData folder, delight read the How to fix when you can't notice the AppData folder part in this post carefully.

Tip: You can also endeavour to fix the fault by deleting the Normal Template.

Fix 2: rebuild the font cache.

1. Open up up a Run dialog box by pressing Start +R or through other ways.
2. Type notepad and hit Enter.
3. Copy & paste the content listed below.
4. Click on the X button and cull Save in the pop-up window.
5. Give it a name with the extension of .bat.
6. Click Save.
7. Right click on the .bat file and cull Run equally administrator.
8. Wait for the process to complete.

Fix 3: gain necessary permissions.

1. Open Run dialog.
2. Type powershell and printing Ctrl + Shift + Enter.
3. Blazon Get-acl C:\Windows\fonts\arial.ttf | Set-Acl -path c:\windows\fonts\*.* and hit Enter.
4. Type Become-acl C:\Windows\fonts\arial.ttf | Set-Acl -path c:\windows\fonts and hit Enter.
5. Look for the commands to finish.

Fix 4: repair the Microsoft Office installation.

1. Open a Run dialog box past pressing Kickoff +R or through other means.
2. Typecpl and click OK.
3. Look for Microsoft Role from the list in Programs and Features window.
4. Right click on Microsoft Office and cull Alter.
5. Choose Yes if there's a User Business relationship Control window appears.
6. Cheque Quick Repair nether How would you lot like to repair your Office programs.
7. Click on the Repair push button at the bottom and click Repair over again in the confirmation window.
8. Look for the procedure to complete.

Set v: remove the Add-ins.

1. Open the problematic program.
2. Go to File > Options.
3. Select Add-ins from the left-hand side of Word Options.
4. Select Word Add-ins after Manage from the right panel and click Go.
5. Uncheck all the options related to Add-in and click OK.
6. Repeat step ii.
7. Select COM Add-ins from the dropdown listing of Manage and click Become.
8. Repeat pace v.
9. Close the programme and open the Word file which triggered the previously.
10. If the fault doesn't appear, please check the options you unchecked in step v and footstep 8.

In one case you lot can confirm which Add-in causes the mistake, you should select it in the Add together-in card and click Remove.

Other fixes:

• Plough off the Automatic Spelling Checking and Grammer Check.
• Reset the Registry Entries of Word.
• Run Microsoft Fix-It or Troubleshooting.
• Create SaveZoneInformation policy in Registry Editor.

How to recover a Discussion document easily?

There Is Bereft Memory Excel

1. Fix 1: select cells gradually.
2. Fix ii: update drivers & disable hardware graphics dispatch.
3. Fix 3: divide an Excel file into different workbooks.
4. Fix 4: set to manage paging file size automatically.

Fix 1: select cells gradually.

• Please do the same for the following section of cells when you choose only part of the entire range you demand to exist filled.
• To brand sure y'all won't reach the limit, please select the concluding row of the previously filled department when you movement on to the latter segments (the 2nd, 3rd, etc.).
• Simply repeat this process to reach the end of the selection needed.

Set up 2.

Footstep 1: update drivers.

1. Open Microsoft Excel.
2. Select File, Account, and Office Update one after another.
3. Click Update Now.
4. Await for information technology to complete.

Step 2: disable hardware graphics acceleration.

1. Click File, Options, and Advanced.
2. Look for Display area from the right panel.
3. Uncheck Disable hardware graphics acceleration.
4. Click OK.

Ready 3: divide an Excel file into different workbooks.

It'southward a skillful selection to separate your big Excel files into a few workbooks 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.

Prepare 4: fix to manage paging file size automatically.

1. Open Command Console.
2. Select System and Security.
3. Click System.
4. Select Advanced system settings from the left sidebar.
5. Keep Advanced tab selected. Click Settings under the Performance expanse.
6. Shift to Advanced tab.
7. Click Alter… under the Virtual memory area.
8. Check Automatically manage paging file size for all drives.
9. Click on the OK button in all Windows to confirm changes.

This part shows you how to solve the insufficient memory or disk space error afterwards information technology appeared in Microsoft Give-and-take/Excel. Meanwhile, it introduces a powerful recovery tool that you can utilise to recover files lost due to all common reasons. Click to tweet

Decision

Undoubtedly, There is non enough memory or disk space is a common error on Windows. You may probably run into it when opening Discussion/Excel or other Function programs. The error will besides occur suddenly when y'all're performing deportment in the programs.

In the previous parts, I accept covered the possible reasons for leading to the error. Then, I have provided several solutions for fixing it yourself. Please read the above content carefully to solve your problem.

There Is Non Enough Retentivity or Deejay Infinite FAQ

What does disk space hateful?

Disk infinite, which is also known as deejay storage, storage capacity, or difficult drive capacity, refers to the maximum amount of files that a disk or bulldoze can keep. Everything y'all installed on the figurer will take up some deejay infinite: operating system, applications, and personal information.

What does it mean when it says there is non enough disk space?

If y'all're receiving an error message saying that your computer doesn't accept enough deejay space, information technology means that in that location is little free space left on your hard drive. Another unusual reason for causing this is that your hard bulldoze runs into trouble and needs to be stock-still.

What does information technology mean when Excel says in that location is not enough disk space?

If you lot see the error message there is not enough available memory or disk space in Excel, it means yous can't open the Excel or save more documents. What you should practice at this fourth dimension is: closing the workbooks or programs you don't need anymore.

How do I bank check my disk space?

• Open File Explorer and look at the Devices and drives section.
• Open Disk Management and look at the capacity & gratuitous space of each drive.
• Open Settings -> choose System -> get to Storage option -> look at the Storage layout.

barnhartfashe1978.blogspot.com

Source: https://www.minitool.com/data-recovery/there-is-not-enough-memory-or-disk-space-word.html

Share this post