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
I am getting below error when Exporting data from my one web application to the Excel 2010 on Windows Server 2008 R2 ,
Type : System.Exception, mscorlib, Version=184.108.40.206, 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
Thursday, May 03, 2012 4:01 AM
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
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 AMModerator
Thank you for your sharing, it will help someone who meets the same issue.
TechNet Community Support
Sunday, July 15, 2012 3:58 PM
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
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 PMI 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 AMWindows 8: Excel 2013: right click, unlock file.