[Fix]: Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory

If you are getting an error message saying “Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory” while opening an Excel file, then this article may be helpful for you to solve this problem.
So, let’s start with our main article.


4 Fixes of Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory

The insufficient memory space or opening of a file downloaded from an internet source can be the cause of this error message. To get rid of this problem we are going to discuss the 4 possible fixes in this article.
We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.


Fix-1: Checking Unblock to Solve Excel Cannot Open or Save Documents Because of Not Enough Available Memory

While trying to open an Excel file downloaded from other sources may be the cause of this error message. To solve this problem and to be able to open the file File Opening Problem.xlsx without any problem in this section we will discuss an easy fix.
➤ Right-Click on the file.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

➤ Select the Properties Option.

checking Unblock option

After that, the File Opening Problem.xlsx Properties wizard will open up.
➤ Check the Unblock option and click on Apply.

Microsoft Excel cannot open or save any more documents because there is not enough available memory
➤ Press OK.

checking Unblock option

In this way, we have fixed the problem and we will be able to open the file.
➤ Click on the File Opening Problem.xlsx file to open it.

checking Unblock option

After that, the file will be opened successfully without an error message.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

Read More: Fix Excel Not Responding and Save Your Work


Fix-2: Disabling Protected View Options

You may have the error message “Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory” for trying to open an Excel file downloaded from the internet. To fix this issue here we are going to disable some Protected View options.
➤ Firstly, open a blank workbook.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

Then, you will be taken to a blank worksheet.
➤ Click on the File option.

Disabling protected view options
➤ Select Options.

Disabling protected view options

After that, the Excel Options dialog box will appear.
➤ Select the Trust Center option.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

➤ Click on Trust Center Settings.

Disabling protected view options

Afterward, you will have different Trust Center options.
➤ Click on the Protected View option and then unclick all of the Protected View options.
➤ Press OK.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

Now, try to open the Excel file by clicking on it.

Disabling protected view options

As you can see, we have successfully opened this file after fixing the issue.

Disabling protected view options

Read More: Excel Not Responding When Opening File (8 Handy Solutions)


Similar Readings


Fix-3: Changing Trusted Locations to Solve Cannot Open or Save Documents Because of Not Enough Available Memory

For not having enough memory spaces you can have an error message saying “Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory” while opening an Excel file. To solve this problem here we will change the location for saving Excel files.
➤ Open a blank workbook.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

Afterward, you will be taken to a blank worksheet.
➤ Click on the File option.

changing trusted locations

➤ Select Options.

changing trusted locations

After that, the Excel Options dialog box will appear.
➤ Select the Trust Center option.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

➤ Click on Trust Center Settings.

changing trusted locations

Then, you will have different Trust Center options.
➤ Click on the Trusted Locations option and then select the Add new location option.

changing trusted locations

➤ Select Browse.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

After that, the Microsoft Office Trusted Location wizard will pop up.
➤ Enter the path of the new location in the Path box and make sure to check the option Subfolders of this location are also trusted.
➤ Press OK.

changing trusted locations

Then, you will be taken to the Trust Center dialog box again.
➤ Press OK.

changing trusted locations

Now, try to open the Excel file by clicking on it.

changing trusted locations

After that, the file will be opened successfully without an error message.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

Read More: [Fixed!] Unable to Open Excel Files Directly by Clicking on the File Icon


Fix-4: Deleting Temp Files

By deleting unnecessary temp files we can make memory spaces and then open our Excel files without any trouble.
To go to the location of the temp files you may need to show the hidden items.
➤ Go to the View tab of the File Explorer window and then check the option Hidden items.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

➤ Now go through the following path.
This PC → Local Disk(C:) → Users → Mima → AppData → Local  Temp
The way of going through this trajectory has been depicted in the following figures.

deleting temp files

The username is different for your computer, so click on the username of your computer.

Microsoft Excel cannot open or save any more documents because there is not enough available memory

deleting temp files

Microsoft Excel cannot open or save any more documents because there is not enough available memory

deleting temp files

➤ Select all of the files in the Temp folder by pressing CTRL+A and then DELETE them.

deleting temp files

After deleting the unnecessary files try to open your Excel files.
➤ Click on the File Opening Problem.xlsx file to open it.

deleting temp files

As you can see, we have successfully opened this file without facing any issues.

Microsoft Excel cannot open or save any more documents because there is not enough available memory


Conclusion

In this article, we tried to cover the possible fixes for Microsoft Excel Cannot Open Or Save Any More Documents Because There Is Not Enough Available Memory. Moreover, you can use some of the Excel file repairing tools available online such as Wondershare Repairit, Easeus, Repair My Excel, etc. If you have any suggestions or questions, feel free to share them in the comment section. And you can check our Exceldemy site for more Excel related content.


Related Articles

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo