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

Fix 1 – Checking Unblock in File Properties

  • 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

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.

  • Open the file.

checking Unblock option

The file should 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!] Why Is My Excel Not Opening Files?


Fix 2 – Disabling Protected View Options

  • Open a blank workbook.

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

  • Click on the File tab.

Disabling protected view options

  • Select Options.

Disabling protected view options

  • 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

  • Click on the Protected View option and uncheck all of the Protected View options.
  • Press OK.

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

  • Try to open the Excel file by double-clicking on it.

Disabling protected view options

We have successfully opened this file after fixing the issue.

Disabling protected view options

Read More: [Fixed!] Excel File Not Opening on Double Click


Fix 3 – Changing the Trusted Locations

  • Open a blank workbook.

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

  • Click on the File option.

changing trusted locations

  • Select Options.

changing trusted locations

  • 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

  • Click on the Trusted Locations option and 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

  • 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

You will be taken to the Trust Center dialog box again.

  • Press OK.

changing trusted locations

  • Try to open the Excel file.

changing trusted locations

The file should 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!] Excel Attachments Not Opening from Outlook


Fix 4 – Deleting Temp Files

  • Go to the View tab of the File Explorer window and check the option Hidden items.

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

  • Go to the following path:
    This PC\Local Disk(C:)\Users\[Name]\AppData\Local\Temp

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 Delete them.

deleting temp files

  • Open the file you need.

deleting temp files

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


Related Articles


<< Go Back to Excel Not Opening Files | Excel FilesLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjima Hossain
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio

2 Comments
  1. Thank you so much for saving me. I have been struggling with opening word and excel files for months, and were about to replace MS. Office with WPS. I succeeded in opening them when trying Fix 1 and 2. You are angel. Wish you all the best.

    • Hello Nhung,

      Your appreciation means a lot to us. We are glad that our article helped you to fix your issues.

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo