Closed Thread
Results 1 to 5 of 5

excel cannot complete this task with available resources

  1. #1
    Registered User
    Join Date
    01-03-2005
    Posts
    2

    excel cannot complete this task with available resources

    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

  2. #2
    Registered User
    Join Date
    01-03-2005
    Posts
    2
    Also, the last time this worked was five days ago, I ran a recovery of these two files for 6 and 7 days ago....still having the same issue. I called Microsoft and spoke to an Excel Engineer, he cannot figure this out. I spoke to another microsoft tech and she kept blaming the issue was either the file size is too big or I need to operate in safe mode or reboot my computer and she even said "its a networking issue, let me transfer you to our network department"
    This issue is happening on all our machines, it is a file issue and not a network or computer issue. I am done trying to get help from microsoft because they had me reboot my machine twice, go into selective startup twice, and read my current cpu information to them like 4 times already.......they are way off base of what the issue is. I am not saying I know what I am talking about, but I at least know it has nothing to do with our computer and has something to do with these 2 files itself. If anyone has any idea how to solve this I would greatly appreciate it.

    Thanks,
    Donald

  3. #3
    Registered User
    Join Date
    08-23-2006
    Posts
    1

    Is there a fix for this?

    Did anyone figure this one out? I am having the same issue. I have a machine with office xp and one with office 2003 and both are giving that error and it definitely not a physical memory issue.

    Any help would be greatly appreciated.

  4. #4
    Registered User
    Join Date
    10-16-2007
    Posts
    1

    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

  5. #5
    Registered User
    Join Date
    04-24-2008
    Posts
    1

    Thumbs down excel cannot complete this task with available resources

    Each time, you close Excel, the programme creates a file called Excel11.xlb.
    If some error of some sort occurs, strange information is collected in this file.

    Just search for this file and delete it.

    Thereafter, everything works fine and you will not get the error message again.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1