How to fix Not Enough Memory to Run Microsoft Excel on Windows

Microsoft Excel mainly gives an insufficient memory prompt when you try to open a file larger than 2GB. But unfortunately, this is not the only cause.

Microsoft Excel is a great program for managing data in spreadsheets. But this does not mean that the program is not without problems. One of the issues discussed recently is the insufficient memory prompt that appears when opening, saving, and editing Excel documents.

The error is not unique to a specific version, ie, it can appear on all versions of Microsoft Excel. Fortunately, eliminating this problem is not too difficult. Just try the solutions below to fix this annoying error.

What causes the "Not Enough Memory to Run Microsoft Excel" error?

Microsoft Excel mainly gives an insufficient memory prompt when you try to open a file larger than 2GB. But unfortunately, this is not the only cause. The problem can also appear due to the following reasons.

1. If background applications use a large amount of system memory, there will not be enough memory to run Excel.

2. Similarly, add-ons installed on Microsoft Excel may take up too much space.

3. Third-party antivirus programs may block certain Excel services and cause problems.

Now that you know the main culprit causing the error, let's check out all the potential fixes for this problem.

How to fix Not Enough Memory to Run Microsoft Excel on Windows

1. Close any unnecessary background apps

Let's start with the most obvious solution by doing as the error prompt asks you to do. When Microsoft Excel runs out of memory, the error message appears as follows: "Not enough memory to run Microsoft Excel. Please close other applications and try again' . retry).

According to the error message, try closing other unnecessary background apps. You can do that by following the steps below.

  1. Open Task Manager with the hotkey Ctrl + Shift + Enter .
  2. In the Process tab , right-click all unnecessary applications and select End task.

Try opening Microsoft Excel again and check if the problem continues.

2. Run Microsoft Excel with admin rights

The error may appear if you are running Microsoft Excel without admin rights. The solution is to always run the program with admin rights. Here's how to do it.

  1. Open the Start menu by pressing the Win key.
  2. Search for Microsoft Excel.
  3. Right click on the Excel application from the results and select Run as administrator .

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 1

  1. If UAC appears, click Yes.

Check if the problem persists.

3. Download the latest Windows update

Outdated Windows version is a possible reason for the problem to occur. Every Windows update comes with new features and bug fixes.

So consider downloading the latest Windows update to fix the problem of insufficient memory in Excel.

4. Update Microsoft Office

The next solution on the list is to download the latest Microsoft Office update. You can do that by following the steps below.

  1. Open Microsoft Excel.
  2. Select Account in the bottom left pane.
  3. Click Update Options before Office Updates.
  4. From the context menu, select Update Now.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 2

Microsoft Office will look for any available updates. If any updates are found, save and close any pending tasks to start the update process.

5. Microsoft Office Repair

The problem can be caused by a temporary glitch or a minor bug in Microsoft Office. You can get rid of this error by using the repair feature. Here's what you need to do.

  1. Open Settings and select Apps from the left panel.
  2. Select Apps & features .
  3. Locate and click the three dots next to Microsoft Office.
  4. Select Modify from the context menu.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 3

  1. The Repair window will appear.
  2. Select Online Repair.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 4

  1. Click Repair twice to start the process.

6. Turn off Cortana

The official Windows digital assistant Cortana is another important reason why you're having problems. The solution is that you will have to disable Cortana.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 5

7. Open Excel in Safe Mode

Various add-ins installed on Microsoft Excel can be the culprit causing the problem. To find out which particular add-in is causing the problem, launch Excel in Safe Mode and check if the problem is fixed. If the problem is resolved, relaunch Excel and disable the add-ins one by one until the problem goes away. When that happens, the add-in you just disabled is most likely the cause of the error.

Here are the exact steps you need to follow.

  1. Hold down the Ctrl key and click the Excel application to open it in Safe Mode.
  2. If the problem is fixed, relaunch Excel in normal mode.
  3. Select Options.
  4. Click Add-ins from the left pane.
  5. Change Manage to COM Add-ins and click Go.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 6

  1. Select the add-in and click OK to disable it.

Repeat the steps for each add-in. After you find the culprit, remove it from Microsoft Excel.

8. Change Trust Center settings

If problems appear when opening Excel files from email clients, the Trust Center settings may be the cause of the problem. You will have to change the Trust Center to resolve the issue. Here's how to do it.

  1. Open Excel > Options .
  2. Select the Trust Center option from the left pane.
  3. Click Trust Center Settings .

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 7

  1. Select Protected View.
  2. Uncheck all options and click OK.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 8

  1. Go back a step and select File Block Settings in the Trust Center.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 9

  1. Uncheck all the boxes and click OK.

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 10

Check if the problem is fixed or not.

9. Change Dynamic Data Exchange (DDE) settings

If you're still having problems, consider changing the Dynamic Data Exchange (DDE) settings in Microsoft Excel. Here's how to do it.

  1. Open Excel > Options > Advanced .
  2. In the General section , uncheck the Ignore other application that use Dynamic Data Exchange (DDE) box .

How to fix Not Enough Memory to Run Microsoft Excel on Windows Picture 11

  1. Click OK to save the changes.

Hope that the above solutions helped you to solve the problem. But if you're still having problems, consider reinstalling Microsoft Office.

4 ★ | 1 Vote | 👨 631 Views
« PREV POST
NEXT POST »