错误信息:Retrieving the COM class factory for component with CLSID {91493441-5A91-11CF-8700-00AA0060263B} failed due to the following error: 8000401a
The server process could not be started because the configured identity is incorrect. Check the username and password. (Exception from HRESULT: 0x8000401A)
服务器是windows 2008 64位的操作系统。解决方法如下:
dcomcnfg打开组件服务(64位操作系统为运行comexp.msc -32)
组件服务—》计算机—》我的电脑—》DCOM配置—》Microsoft Excel Appliction
右键属性—》安全—》添加设置用户
组件服务—》计算机—》我的电脑—》DCOM配置—》Microsoft Excel Appliction
右键属性—》本地一》勾选 Run application on the computer where the data is located
注意,在启动和激活权限中,要同时勾选本地启动和本地激活的选项
------------------------------------------------------------------------------------------------------------------------
注意,如此设置完成之后,在操作Excel时可能会报内存或磁盘空间不足的错误,需要按如下方法进行解决:
右键属性—》标识—》改为交互式用户
------------------------------------------------------------------------------------------------------------------------
注意:如果选择"交互式用户",则必需登录到系统,IIS 用户才有权限访问EXCEL COM