Skip to content

Published: June 6, 2015 | Applies to:

Learn how to fix "Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space" error for spreadsheets.

There exists two conditions when you’re expected to receive the error mentioned in title of this post. Firstly, when you’re running out of space on your system hard drive and secondly, when a feature of Microsoft Office is causing this issue. In the latter case, where the problem is not actually related to memory space, but still you’re receiving the following error message which directly indicates the low disk space condition:

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

To make more memory available, close workbooks or programs you no longer need.

To free disk space, delete files you no longer need from the disk you are saving to.

Microsoft Excel Cannot Save Any More Documents Because There Is Not Enough Available Memory Or Disk Space

We faced this problem with a Excel spreadsheet downloaded from Google Docs. The spreadsheet size was less than 1MB and we have GBs of free space on the disk where this spreadsheet was saved. Also we’ve another spreadsheets saved on same location and created by Excel on local computer, which we can open without this error. So this clearly shows that this is not a memory related issue at all, plus the problem persists with spreadsheets downloaded from the Internet only.

Read : How to prevent Internet usage in Office 2013?

After a bit of research on this, we summarize that the Protected View feature of Office 2013 / Excel 2013 is root cause in generating the hiccup, so here is how to fix it:

FIX : Microsoft Excel Cannot Open Or Save Any More Documents Because There Is Not Enough Available Memory Or Disk Space

1. Open any new document in Excel, and click FILE -> Options.

Microsoft Excel Cannot Save Any More Documents Because There Is Not Enough Available Memory Or Disk Space

2. Next, in the left pane of Excel Options window shown below, select Trust Center. Now in corresponding right pane click on Trust Center Settings button:

Microsoft Excel Cannot Save Any More Documents Because There Is Not Enough Available Memory Or Disk Space

3. Moving on, in the Trust Center settings window, select Protected View from the left pane. Finally, uncheck/disable all options in right pane there, which are:

  • Enable Protected View for files originating from the Internet
  • Enable Protected View for files located in potentially unsafe locations
  • Enable Protected View for Outlook attachments

Microsoft Excel Cannot Save Any More Documents Because There Is Not Enough Available Memory Or Disk Space

Click OK, OK and then restart your system. After rebooting the machine, try to open the spreadsheet with which you’re getting error, you’ll find that this time it opens as expected.

That’s it! Checkout how to make files password protected in Office 2013.


SHARE: Facebook Google+ Twitter

53 Comments

  • This did not work for me. Ive been trying to find a fix for this for days now and nothing works. Even the boxes when selecting don’t match up sometimes. What is ther about 20 different versions of office and windows 10? I just dont get it.

  • Kapil Arya

    ^^ Then you need to make sure, you’ve enough space on the harddisk :)

  • Solved my problem. Thank you.

  • Kapil Arya

    ^^ Glad we could help :)

  • Thank you! This solved my problem with Excel 2016.

  • Kapil Arya

    ^^ Happy to help!

  • Thank you! solved my problem.

  • Kapil Arya

    ^^ Thanks for feedback!

  • Thanks man, you made my day ! What a piece of crap ! Especially the error message that had nothing to do with it whatsoever !

  • Kapil Arya

    ^^ Great to see it worked!

  • Finally solved my issue! Thanks!!

  • worked for me thanks using Office 2013 on a surface Pro 3

  • Kapil Arya

    ^^ Cool :)

  • problem resolved……..thanks…

  • Kapil Arya

    ^^ Glad it helped! :)

  • tankyou for data
    very nice

  • Resolved, thanks for help

  • Kapil Arya

    ^^ Awesome 😊

  • thanks man :)

  • Many thanks, got me out of a hole.

  • Kapil Arya

    ^^ Nice ☺️

  • Thank you Kapil Arya

  • I have 700 gb available – still getting this error. I have MS Excel for Mac 2016. There is no Trust Center or Protected View settings that I can find. Any advice?

  • Kapil Arya

    ^^ The settings should be there. By the way which edition of Office you’re using?

  • thanks a lot you solve my problem

  • Kapil Arya

    ^^ Perfect 😎

  • Thank you!!! I was going nuts, but your solution worked. Yay!

  • Kapil Arya

    ^^ Thanks for your feedback!

  • problem showing same i have remove all protected view options but problem same in office 2016

  • Kapil Arya

    ^^ No idea why it didn’t worked for you! Anyway, try repairing Office and see if it helps: http://www.kapilarya.com/how-to-repair-office-2013-offline

  • Thanks problem got solved,…..

  • Kapil Arya

    ^^ Great!

  • Thanks for your help

  • Kapil Arya

    ^^ :)

  • This was AWESOME! Totally fixed the problem I was having. Thank You!

  • Kapil Arya

    ^^ Very nice!

  • this worked for me:
    file–>options–> Trust center –> trust center settings –> File Block Settings –> activa la opción Open selected file types in protected view and allow editing

  • Kapil Arya

    ^^ Thanks for adding this!

  • Thank you !!!! It works perfect

  • Kapil Arya

    ^^ Excellent 😊

  • Trust center settings did not work. This did work:

    youtube.com/watch?v=3ugck2ml_WE

    I had to change the registry file to point to C:\windows\temp

  • thkz bro..!you made it easy.

    Great JOb.

  • Kapil Arya

    ^^ 😎

  • Tks, guys

  • Kapil Arya

    ^^ Very cool!

  • Thanks a lot !! It worked :-

  • Kapil Arya

    ^^ Welcome!

  • dear team,
    Thanks for the solution.

  • Kapil Arya

    ^^ Nice!

  • Thanks a Lot !
    Solved my long time issue…
    Appreciated!

  • Kapil Arya

    ^^ Happy to hear that!

  • solved my issue thanks

  • Kapil Arya

    ^^ 👍

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    What's New


    Recent Comments

    • Jonathan : Has there been any development on this? I have tried multip...

      1 day ago

    • Kapil Arya : ^^ Thanks for your input 😊...

      1 day ago

    • inalzninz : mine is not (javascript) its (loaditem) please solve this er...

      1 day ago

    • Joshua : I know this is an old thread, but thought I'd leave a commen...

      1 day ago

    • Kapil Arya : ^^ Happy to help ☺️...

      2 days ago

    • frozen nerd : i also tried uninstalling avast, disabling all startup progr...

      2 days ago


    Windows Group Policy Troubleshooting