excel cannot complete this task with available resources

类型:【转载】
原文作者:【Renzo Beggia】
日期:【10-16-2007】
原文地址：http://www.excelforum.com/excel-general/331985-excel-cannot-complete-this-task-with-available-resources.html

 

问题：

I am trying to open 2 excel documents at the same time. When I open the second one I get this error:
‘excel cannot complete this task with available resources’
If I try to open the second file first and then open the first file I get the same error. I get this error only with these 2 files, If I try to open up any other combo of files they open up just fine.

We are on a network, this happens on all users machines, including the main server which in a xeon 3.4 gh with 8 gigs of ram. I also tried copying the file from the server and pasting it onto a machine…..same error.

These files are password protected so I open them read only. But, we have tried entering in the password…still same error. Also, we have tried unpassword protecting the files and still get the same error.

the files are 5MB each, but I have tried opening files that are 15MB each and they open just fine. It has to be something in these two files, but I do not know what.

Version: Excel 2003
Workstation Platform: Windows XP Pro
Server Platform: 2003 Enterprise

kbase: http://support.microsoft.com/kb/331863 <– 2002 only…not 2003

Please Help!

Thanks,
Donald

 

解决方案：

Solution !!

go to :
C:\Documents and Settings\*USERNAME*\Application Data\Microsoft\Excel

and delete all the files in that folder.
this will solve your problem !!

ciao,
Renzo Beggia