Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
2146827284Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space

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

  • Wednesday, May 02, 2012 8:57 AM
     
     
    Sign In to Vote
    0

    Hi Experts,

    I am getting below error when Exporting data from my one web application to the Excel 2010 on Windows Server 2008 R2 ,

    02/29/2012 18:54:50
    Type : System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b11a5c481859e569
    Message : -2146827284Microsoft 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.

    The disk space is 30 GB free, I have cleared all the temp files, increased the virtual memory & internet temp files size to max but no luck

     

All Replies

  • Thursday, May 03, 2012 4:01 AM
     
     Answered
    Sign In to Vote
    2

    I have resolved this.

    step1 :  Go to run type dcomcnfg
    Step2:   Click >Component services >Computes >My Computer>Dcom config> and select micro soft Excel Application>
    Step3:   Right Click on Microsoft Excel Application>Properties>Give Asp.net Permissions
    Step 4: Select Identity table >Select interactive user >select ok

    • Marked As Answer by VLCC Thursday, May 03, 2012 4:01 AM
    •  
     
  • Thursday, June 14, 2012 4:44 PM
     
     Answered
    Sign In to Vote
    2

    If you're running 64-bit Windows you have to run Component Services in 32-bit mode before you can see Microsoft Excel Application to modify its properties.  

    You can run Component Services in 32-bit mode two ways: 

    1.  dcomcnfg -32 

    2.  MMC comexp.msc /32


     
  • Friday, June 15, 2012 1:05 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    Thank you for your sharing, it will help someone who meets the same issue.

    Jaynet Zhang

    TechNet Community Support

     
  • Sunday, July 15, 2012 3:58 PM
     
     
    Sign In to Vote
    0

    sometimes, you create new application pool and cann't solve it via DCOMCNFG.

    then there is another method to do:

    set the identity (Model Name) of application pool to "LocalSystem"

    I don't know the root cause, but it could solve some problems.

     
  • Friday, August 17, 2012 4:52 PM
     
     
    Sign In to Vote
    0

    Disregard my comment below, the problem reoccured.  

    This is the most awesome thread I have seen all month!  Thanks to you guys for this helpful, concise information.  Just to mention, I did not see an option "Give Asp.net Permissions."  However I went to the Security tab and customized the permissions to allow Full Control to everyone.  (This is a single-person computer).

    • Edited by laurelii Tuesday, August 21, 2012 7:38 PM
    •  
     
  • Saturday, August 25, 2012 7:15 PM
     
     
    Sign In to Vote
    0
    I ran dcomcnfg -32 still cannot  see "micro soft Excel Application" in the decom CNFG.  My computer is Win7 64bits.  Can you shed the light?
     
  • Thursday, January 17, 2013 2:14 AM
     
     
    Sign In to Vote
    0
    Windows 8: Excel 2013: right click, unlock file.