Not enough memory to run Microsoft Excel [Fixed]

Should you see Not enough memory to run Microsoft Excel error whereas launching Excel, then the options offered on this article might assist you to repair it. This error prevents customers from working in Microsoft Excel as a result of they’ll’t open any spreadsheet. Some customers have seen this error whereas attaching an Excel file in Microsoft Outlook or whereas opening an Excel file from Outlook and from one other e-mail consumer.

The whole error message is as follows:

Not enough memory to run Microsoft Excel. Please shut different purposes and take a look at once more.

Not enough memory to run Microsoft Excel

The next fixes will assist you to eliminate this drawback. Earlier than you proceed, shut different working purposes and see when you can open Microsoft Excel. If not, restart your pc and examine if the problem is mounted.

1. Run Excel as an administrator
2. Make the Excel folder empty
3. Change your default printer
4. Troubleshoot Excel in Secure Mode
5. Troubleshoot your pc in a Clear Boot state
6. Change the Belief Middle settings
7. Toggle the Dynamic Knowledge Trade (DDE) mode
8. Examine the standing of the Home windows Defender Firewall service
9. Unblock the Excel file
10. Flip off Preview Pane in File Explorer
11. Delete short-term recordsdata and folders
12. Restore Workplace

Under, we’ve got defined all these fixes intimately.

1] Run Excel as an administrator

Generally the issue happens due to administrative privileges. To examine this, launch Microsoft Excel as administrator after which see when you get the identical error message. To try this, right-click on the Microsoft Excel shortcut and choose Run as administrator.

If this fixes your drawback, you may make Excel at all times run as administrator.

2] Make the Excel folder empty

While you create a brand new spreadsheet or edit the present one, Microsoft Excel creates its unsaved copy within the Excel folder. That is how Excel recovers your unsaved doc when your pc or Excel crashes out of the blue. These recordsdata stay in that folder till you save your spreadsheet. By default, these short-term recordsdata are positioned within the Roaming folder. Aside from that, some short-term cache recordsdata may be created in that folder.

Make the Excel folder empty and examine if this fixes your drawback. To try this, observe the steps under:

1. Open the Run command field by urgent the Win + R keys.
2. Kind %appdata% and click on OK. This command will instantly open the Roaming folder in your C drive.
3. Now, open the Microsoft folder after which open the Excel folder. You may even see some short-term recordsdata and folders there.
4. Transfer all of the recordsdata and folders to one other location so as to make the Excel folder empty.
5. Open Microsoft Excel and see if the issue disappears.

If the issue nonetheless happens, you possibly can transfer the recordsdata again to the Excel folder.

3] Change your default printer

Generally, the issue happens when Excel is just not in a position to entry the default printer. To examine this, change your default printer. You can too make a digital printer as your default printer, like Microsoft Print to PDF or Microsoft XPS Doc Author. After performing this step, examine if the issue happens.

4] Troubleshoot Excel in Secure Mode

There could be some problematic add-ins in Excel which are inflicting the issue. To examine this, you’ve gotten to troubleshoot Excel in Secure Mode. Examine if you’re in a position to launch Excel in Secure Mode. If sure, a few of your Add-ins are the perpetrator.

To launch Excel in Secure Mode, open the Run command field and sort excel /protected. After that, click on OK. This may open Excel in Secure Mode. Now observe the steps under:

1. Go to “File > Options.”
2. Choose Add-Ins from the left aspect.
3. Click on on the Handle drop-down and choose COM Add-ins. Click on Go.
4. Deselect anybody add-in to disable it and click on OK.
5. Shut Excel in Secure Mode and launch Excel in regular mode. See if the problem seems. If sure, repeat the above steps to disable one other add-in after which launch Excel in regular mode once more.

The above steps will assist you to discover the problematic add-in. As soon as you discover it, take away it from Excel.

5] Troubleshoot in a Clear Boot state

If there isn’t a problematic add-in in Excel, the problem may happen due to a conflicting background or startup app. You’ll be able to simply determine that program by beginning your pc in a Clear Boot state. After beginning your pc in a Clear Boot state, launch Microsoft Excel and see if the “Not enough memory to run Microsoft Excel” message seems. If not, there’s a program that’s conflicting with Microsoft Excel due to which Excel is displaying this error.

To determine that program, allow a number of the disabled packages within the Clear Boot state, after which begin your pc in a traditional state. Launch Excel after beginning your pc within the regular state and see if the error happens. If sure, a number of the packages you’ve gotten simply enabled are inflicting the issue. To determine these packages, disable the enabled packages one after the other and launch Excel every time you disable a program. This may assist you to determine the problematic startup software.

Associated: Excel is sluggish to reply or stops working

6] Change the Belief Middle settings

In case you are unable to connect an Excel in Outlook or if you’re getting the error message after opening the Excel file from Outlook or one other e-mail consumer, change the Belief Middle settings and see if it really works.

1. Open Microsoft Excel.
2. Go to “File > Options.”
3. Now, go to “Trust Center > Trust Center Settings” and choose Protected View from the left aspect.
4. Uncheck all of the choices and click on OK.
5. Now, open the Belief Middle Settings once more and choose File Block Settings from the left aspect.
6. Uncheck all of the choices and click on OK.

7] Toggle the Dynamic Knowledge Trade (DDE) mode

This resolution can be for the customers who’re receiving the error message “Not enough memory to run Microsoft Excel” whereas attaching an Excel file to Outlook or whereas opening sure Excel recordsdata.

1. Launch Microsoft Excel.
2. Go to “File > Options > Advanced.”
3. Scroll down till you discover the Normal part.
4. Allow the “Ignore other applications that use Dynamic Data Exchange (DDE)” possibility.
5. Click on OK and shut Microsoft Excel.
6. Watch for a couple of seconds and launch Excel once more.
7. Now, disable the “Ignore other applications that use Dynamic Data Exchange (DDE)” possibility.
8. Click on OK and shut Excel.

This could assist. If not, strive the following resolution.

8] Examine the standing of the Home windows Defender Firewall service

For some customers, beginning the Home windows Defender Firewall service mounted the problem. You must also do that. Open the Providers app and examine the standing of the WIndows Defender Firewall service. Whether it is stopped, begin it. The steps for a similar are written under:

1. Open the Run command field and sort companies.msc.
2. When the Providers app seems in your display screen, find the Home windows Defender Firewall service.
3. Its standing ought to present Operating. Whether it is stopped, double-click on it to open its properties.
4. Click on on the Startup kind drop-down and choose Automated.
5. Now, click on Begin to begin the service.
6. Click on Apply after which click on OK.

9] Unblock the Excel file

In case you are getting the error message whereas opening some particular Excel recordsdata, you possibly can do that repair. This technique can be helpful for customers who usually are not in a position to open the Excel file from Outlook or one other e-mail consumer.

The steps to unblock an Excel file are written under:

1. Proper-click on the Excel file which is supplying you with the error.
2. Choose Properties.
3. Choose the Normal tab.
4. Allow the Unblock possibility.
5. Click on Apply after which click on OK.

Learn: Repair VBA Run-time error Class not registered in Excel.

10] Flip off Preview Pane in File Explorer

Generally, the File Explorer’s Preview Pane causes issues on a Home windows pc. The Preview Pane reveals the preview of the recordsdata that you choose. Whether it is enabled in your system, disable it after which examine when you can open Microsoft Excel.

To disable the Preview Pane in Home windows 10, open File Explorer and click on on the View tab. Now, choose the Preview Pane possibility to allow or disable it. In Home windows 11, open File Explorer, then go to “View > Show” and uncheck the Preview Pane possibility.

If this works for you, you possibly can completely disable the Preview Pane in File Explorer through the Group Coverage Editor and the Registry Editor.

11] Delete short-term recordsdata and folders

One other efficient and simple resolution that you may strive is to delete the short-term recordsdata and folders. To take action, undergo the next steps:

1. Open the Run command field and sort %temp%. Click on OK.
2. This command will open the folder containing short-term recordsdata and folders.
3. Delete all of the recordsdata and folders contained in the Temp folder.

Now, open Microsoft Excel and see if the error message seems once more.

12] Restore Workplace

If a few of your Microsoft Workplace recordsdata get corrupted, chances are you’ll expertise a number of points in numerous Workplace purposes. If the issue that you’re presently dealing with is going on due to this, repairing the Workplace software may help. First, run the Fast Restore. If this doesn’t assist, run an On-line Restore.

Learn: Excel not scrolling easily or correctly? Allow Excel easy scrolling.

How do you repair There isn’t enough memory to full this motion in Microsoft Excel?

Should you see the There isn’t enough memory to full this motion error in Microsoft Excel, first strive to set up the newest Home windows Updates (if obtainable). If this doesn’t work, examine if there’s any add-in inflicting the issue. To take action, you’ve gotten to troubleshoot Excel in Secure Mode.

Generally, issues happen when Excel is just not in a position to entry the default printer. Therefore, one other resolution to repair this drawback is to change the default printer. You can too strive to launch Excel after disabling your antivirus.

How do I repair There’s not enough memory or disk area to run in Excel?

Launch Excel as administrator and see if the problem seems. If sure, you’ve gotten to strive another fixes, like troubleshooting Excel within the Secure Mode to determine the problematic add-in (if any), troubleshooting your pc in a Clear Boot state to discover the conflicting software (if any), turning off the Preview Pane in File Explorer, and so forth. If nothing works, run an internet restore or uninstall and reinstall Microsoft Workplace.

Hope this helps.

Learn subsequent: Can’t print from Excel? Repair Excel printing issues in Home windows 11/10.