Results 1 to 8 of 8

Thread: Excel Cannot Complete task with Available resources

  1. #1

    Excel Cannot Complete task with Available resources



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have recently obtained a new PC with Windows 7 and 4GB iof rqam. From time to time when I have only 1 or 2 Excel files open and try to open another file (Excel 2007), a message cames up , "Excel cannot complete the task with available resources"

    It would be appreciated if you would be able to assist me

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    It does all depend on what else is running on your pc and what tasks the other two excel files are performing and how intensive those tasks are.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  3. #3

    Excel Cannot Complete task with Available resources

    Hi Simon

    Thanks for the reply. The Excel files that I had open today are very small. I also has Outlook open as well as one small program. When I had XP on my old PC , I never experienced this problem.

    I'm sure that something else is causing this problem, but the million dollar question is what

    Regards

    Howard

  4. #4
    Hi Simon

    Do you think that a registry cleaner such as CCleaner may be able to sort out the problem or do you have any other suggestions that may sort the problem out?

  5. #5
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi Howard

    I experienced the same problem as you, with both XL2007 and XL2010
    Yes, use CCleaner on regular basis.
    Since I disabled all Add ins, I don't seem to have had the problem.
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

  6. #6

    Excel Cannot Complete task with Available resources

    Hi Roger

    Thanks for the reply andinformation

    As far as I know all my add-ins have been disabled, but I will check this again when I get into the office.

    I will install CCleaner on my office PC and run a clean as well

    Regards

    Howard

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    I'll add another vote for CCleaner. Curious if you got this sorted out Howard?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  8. #8

    Excel Cannot Complete task with Available resources

    Hi Ken

    Thanks for the reply. I have run CCleaner and since then, I no longer have this problem, except when If I open an Excel attachment and i have several Excel files open

    Regards

    Howard

Posting Permissions

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