Fix: Microsoft Excel Cannot Open Or Save Any More Documents Because There Is Not Enough Memory

Microsoft Excel is an app that most of us prefer using when handling data and when we need to save important data for important tasks or for future use. However, just like any other app or program, even the Excel comes with its own set of problems.


ADVERTISEMENT

Many times, you may receive an excel sheet via email from someone or you downloaded a spreadsheet from some website, and when you try to open the Excel sheet, bang comes an error message, “Microsoft Excel cannot open or save any more documents because there is not enough memory“.

Apparently, the issue is not related to your system memory at all. It’s mostly a security warning related to the specific file, that prevents you to open the Excel file for some reason. These warnings can be specifically for the files downloaded from the web, but may not be the same for all files.

So, how do we fix this issue? Let’s see how.

Method 1: Unblock through Properties

 

Step 1: Go to your desktop and right-click on the Excel file (that’s giving the error while opening), and select Properties from the right-click menu.

 

Desktop Excel File Right Click Properties


ADVERTISEMENT

 

Step 2: In the Properties window, under the General tab, go straight towards the bottom, up to the Security section. Check the box next to Unblock.

Press Apply and then OK to save the changes and exit.

 

Properties General Tab Security Unblock Check Apply Ok

 

And, that’s it. You can now try opening the Excel file and it should open without any error. However, if this does not work, try the 2nd method.

Method 2 – Tweak Trust center settings

1. Open Microsoft Excel.

2. Now, Click on options

 

Excel Options Min

 

3. Click on Trust center from the left menu.

4. In the right side, click on Trust center settings.

 

Trust Center Settings Min

 

5. Now, click on protected view from the left menu.

6. Disable all protected view options by unchecking them.

Disable Protected View Excel Min

Method 3: Clear Temp files

 

Step 1 – First of all Unhide all hidden files in your system. If you do not know , how to unhide hidden files read this article

Step 2: Now, Press Windows key and R key together to open run.

Step 3 – Now, type Appdata in it and click OK.

Appdata Min

Step 4 -Now, click on Local folder to go inside it.


ADVERTISEMENT

Step 5 – Now, Click on Temp folder inside and click on it.

Step 6 – Now, Delete all files inside Temp and make it empty.

Step 3: Now, press the Ctrl + A keys together on your keyboard to select all the temporary files in the folder, and hit Delete.

 

Ctrl + A Select All Files Delete

 

 

That’s all. Now, try to open the Excel file and it should open smoothly without any errors.

ADVERTISEMENT

5 thoughts on “Fix: Microsoft Excel Cannot Open Or Save Any More Documents Because There Is Not Enough Memory”

  1. Thanks for the accurate info that solved the problem for me. This is but one of Win 10 obfuscations.
    When failing to perform a normal function the error message is completely misleading.
    One should not have to frequently research on the web to get past MS’ blocking normal, ordinary paid for operations. In my opinion this is a symptom of a failing product.

Comments are closed.