如何修复'Microsoft Excel无法打开或保存更多文档' [英] How to fix 'Microsoft Excel cannot open or save any more documents'

问题描述

我使用IIS 7.5在Windows 7 64位上运行C＃ASP.NET 4.5 Web应用程序。它使用的应用程序池名为ASP.NET v4.0，其标识为ApplicationPoolIdentity。该应用程序使用MS Office Interop（Microsoft Excel 14.0对象库）。

I am running C# ASP.NET 4.5 web application on Windows 7 64-bit using IIS 7.5. The application pool it uses has the name 'ASP.NET v4.0' and its identity is ApplicationPoolIdentity. The application uses MS Office Interop (Microsoft Excel 14.0 Object Library).

在行 wBook = wBooks.Add（Missing.Value）; ，它会抛出以下错误：

At line wBook = wBooks.Add(Missing.Value);, it throws the following error:

Microsoft Excel无法打开或保存更多文档，因为
的可用内存或磁盘空间不足。

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

u2022要提供更多可用内存，请关闭不再需要的工作簿或程序。

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

u2022要释放磁盘空间，请从保存到的
磁盘中删除不再需要的文件：
Microsoft.Office.Interop .Excel.Workbooks.Add（对象模板）

u2022 To free disk space, delete files you no longer need from the disk you are saving to.: at Microsoft.Office.Interop.Excel.Workbooks.Add(Object Template)

1）我给了帐户IIS apppool\ASP.NET v4.0已满在DCOM配置中控制MS Excel应用程序。

1) I gave the account IIS apppool\ASP.NET v4.0 full control on MS Excel Application in DCOM Config.

2）我在'C：\ Windows \SysWOW64上给了IIS apppool\ASP.NET v4.0完全控制\ config \systemprofile'并在其中创建了一个Desktop文件夹。

2) I gave IIS apppool\ASP.NET v4.0 full control on 'C:\Windows\SysWOW64\config\systemprofile' and created a Desktop folder in it.

3）我需要继续使用Interop，但不建议这样做。

3) I need to continue using Interop though it's not recommended.

4）该应用程序在Windows Server 2003 / Windows XP 32位上运行正常。

4) The application works fine on Windows Server 2003/Windows XP 32-bit.

5）MS Office 2010（64位，机器上安装了试用版。

5) MS Office 2010 (64-bit, trial version) is installed on the machine.

6）我不想更改应用程序。从ApplicationPoolIdentity到网络服务等的池标识.ApplicationPoolIdentity是IIS 7中新的标识类型，建议使用它。

6) I would prefer not to change the app. pool identity from ApplicationPoolIdentity to Network Service etc.. ApplicationPoolIdentity is the new type of Identity in IIS 7 and it's recommended.

如果选择交互式用户，它可以正常工作（我在DCOM配置中以管理员身份登录，但它会导致其他问题。我需要使用ASP.NET的v4.0启动用户。所以看起来这是一个许可问题。

It works fine if I select 'Interactive User' (I have logged in as an admin) in DCOM Config, but it causes other problems. I need to use 'Launching User' which is ASP.NET v4.0. So it looks like it's a permission issue.

请帮忙。
谢谢。

Please help. Thank you.

推荐答案

右键单击带有文件浏览器的文件，选择属性，然后常规标签，然后点击取消阻止按钮。此错误消息非常容易引起误解。

Right click on the file with file explorer, choose Properties, then General tab and click on the Unblock button. This error message is very misleading.

这篇关于如何修复'Microsoft Excel无法打开或保存更多文档'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！