How-To-Config

Excel not enough available memory or disk space available

Excel can sometimes throw to following error to you:

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.
  • excelerror
    Weird thing is that it doesn’t matter how fast your Computer / Notebook is. We did recently upgrade our machines to Core i5 / 8GB Memory and some users still get this error message. Below instructions does fix this in most circumstances:

    1. Go to Run -> dcomcnfg (for 64 bit: dcomcnfg -32)
    dcomrun
    2. Click Component Services -> Computers -> My Computer -> DCOM Config
    dcomconfig
    3. Right-click on “Microsoft Excel Application” and select “Properties
    msexcelapplication
    4. On the “Identity” tab select “The interactive user.
    identitytab
    5. Click “Apply” to save the settings. Restart Microsoft Excel and the issue is resolved

    Notes: Some people advice to also give “ASP.net” Read/Write permissions. You can do this on the “Security” tab. In my case this was not needed in order to fix the issue.

    19 Responses so far.

    1. Radan Annachi says:

      Microsoft Excel Application is not available in Component Services.

      My OS is Win 8.1 Pro & MS Office Home and Business 2013

    2. Dennis says:

      THanks a lot sir… it works… thank you very much

    3. Ganesh says:

      how to check microsoft equation 3.0

    4. Jessie says:

      Followed the steps, but I can’t found M.E.Application too as Radan above.

      Any other way to solve?

      Thanks

    5. shyam says:

      Try this. Right click on the file and select Properties and in the click on Unblock and try opening the file again

      -Shyam

    6. Saravanan A says:

      It working great.

      Very Very Thankyou so much.

      Regards,

      Saravanan A

    7. koushik says:

      id did not worked for me is there any another process pleaseeee i am using windows 10

    8. koushik says:

      it did not worked for me is there any another process

    9. DSloyer says:

      The Microsoft Excel Application entry does is not found in 32bit or 64bit versions of Dcomcnfg for Office 365 2016 Click to Run.

      Checking Application GUIDs at the end of the list.

    10. ABHIRUP says:

      Not working.

    11. Dayo Adeyanju says:

      The solution is easy – it’s just a stupid error message that has nothing to do with the actual problem, and the problem is actually a microsoft feature, as often is:
      – Office now has some kind of “protected-mode” feature, which prevents office apps from doing certain things under certain conditions.
      – One of them is to stop excel from opening attachments coming from outlook 🙁

      Just go in Excel options, trust center, settings, and untick all the options about “protected view”.

      Save and voila, suddenly excel can open all your files and has absolutely no problems with your gigs of free memory.

      Original post by GCGus Cops on https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/microsoft-excel-cannot-open-or-save-any-more/961a153e-6c68-4b22-b896-94601a28d7e2

    12. Scott Seifel says:

      I am using Office 2016 on Win 10 and I am receiving this “not enough available memory…’ error. This is what worked for me:

      Right-mouse clicked on Word or Excel file; selected Properties.

      Under the General tab, at the bottom there is a section titled “Security:”

      It states “This file came from another computer and might be blocked to help protect this computer.”

      I checked off “Unblock” and I was able to open the file.

    Leave a Reply