Questions

Excel cannot complete this task with available resources error

Tags:
+
0 Votes
Locked

Excel cannot complete this task with available resources error

jenl2881
Our firm recently upgraded from Office 2000/2003 (some had 2000, some 2003) to Office 2007. We have been having some issues with Excel since. Some users are getting errors such as "Excel cannot complete this task with available resources. Choose less data or close other applications." One partner told me he gets the error when he had a Word document with an excel link or is in Engagement Manager and is trying to open an excel document. Others are starting to get the message as well. Any ideas?
  • +
    0 Votes
    Jacky Howe

    Troubleshooting Microsoft Excel
    Excel has no normal.dot file like Microsoft Word, so troubleshooting it generally takes steps that are a little more difficult right from the start, but there's only a few things that could be wrong.

    If all your applications are acting up, then you should probably clean up your hard drive first.

    Files Won't Open
    This is often caused by one stupid setting. It's under Tools?Options, General tab. Make sure that Ignore Other Applications is not checked.

    XLStart Folder Issues
    First, if Excel appears to be trying to open a bunch of files when you launch it, check out the information about the XLStart folder. You may not need to come back to this article.

    XLB File
    What the heck is an XLB file? It's where all your toolbar customization is stored. Sometimes, it becomes corrupt, and hoses up your Excel so that you can't use it. So, with Excel closed, you do a search for *.xlb files and you rename or delete them. Then relaunch Excel.

    Dump the Excel Windows Registry Key
    There are many people who would rather that I didn't tell you how to do this. But any adult that's paying any attention can follow my steps. What we're doing is removing Excel from the Windows registry. When you launch Excel again, it will re-register itself, so you can expect it to take a little longer to launch than usual.

    Hit Start, Run and type regedit and hit enter. Browse, just like you would in Windows Explorer or My Computer, to the following folder:

    My Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\X.X\Excel

    X.X will be as follows, depending on your version of Word:

    Excel 2000 is 9.0

    Excel 2002/XP is 10.0

    Excel 2003 is 11.0

    Once you find it, right click the Excel folder, and choose Rename. Rename it to OldExcel. This is a quickie method of backing up your registry. Close the Registry Editor.

    Launch Excel.

    http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm

    +
    0 Votes
    jenl2881

    We will try it, but now 5 people are getting the same error.

    +
    0 Votes
    jenl2881

    Our whole office has Office 2007, so compatibility is not the issue.

    +
    0 Votes
    ken

    I had a very similar error with a Microsoft Works client. An XP update about 2 weeks ago gave this error in the Works spreadsheet. They added a patch to fix the Works issue. Might be the same. Do a manual update and choose "custom".

    +
    0 Votes
    jenl2881

    no updates are available. We check regularly. Could this be an issue with the Office SP1 update? The files were going slow after the upgrade, though, and still after the sp1 install.

    +
    0 Votes
    tangoboy98

    http://support.microsoft.com/kb/292471

    This behavior can occur if you define names that indirectly refer to other nested names that are more than 20 levels deep. When you add or use a name that exceeds that level of indirection in a formula, you receive this error message. You also receive this error message when you delete a name that is referenced by more than 20 levels of defined names

    +
    0 Votes
    tangoboy98

    http://support.microsoft.com/kb/292471

    This behavior can occur if you define names that indirectly refer to other nested names that are more than 20 levels deep. When you add or use a name that exceeds that level of indirection in a formula, you receive this error message. You also receive this error message when you delete a name that is referenced by more than 20 levels of defined names.

    APPLIES TO

    * Microsoft Office Excel 2007
    * Microsoft Office Excel 2003
    * Microsoft Excel 2002 Standard Edition

  • +
    0 Votes
    Jacky Howe

    Troubleshooting Microsoft Excel
    Excel has no normal.dot file like Microsoft Word, so troubleshooting it generally takes steps that are a little more difficult right from the start, but there's only a few things that could be wrong.

    If all your applications are acting up, then you should probably clean up your hard drive first.

    Files Won't Open
    This is often caused by one stupid setting. It's under Tools?Options, General tab. Make sure that Ignore Other Applications is not checked.

    XLStart Folder Issues
    First, if Excel appears to be trying to open a bunch of files when you launch it, check out the information about the XLStart folder. You may not need to come back to this article.

    XLB File
    What the heck is an XLB file? It's where all your toolbar customization is stored. Sometimes, it becomes corrupt, and hoses up your Excel so that you can't use it. So, with Excel closed, you do a search for *.xlb files and you rename or delete them. Then relaunch Excel.

    Dump the Excel Windows Registry Key
    There are many people who would rather that I didn't tell you how to do this. But any adult that's paying any attention can follow my steps. What we're doing is removing Excel from the Windows registry. When you launch Excel again, it will re-register itself, so you can expect it to take a little longer to launch than usual.

    Hit Start, Run and type regedit and hit enter. Browse, just like you would in Windows Explorer or My Computer, to the following folder:

    My Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\X.X\Excel

    X.X will be as follows, depending on your version of Word:

    Excel 2000 is 9.0

    Excel 2002/XP is 10.0

    Excel 2003 is 11.0

    Once you find it, right click the Excel folder, and choose Rename. Rename it to OldExcel. This is a quickie method of backing up your registry. Close the Registry Editor.

    Launch Excel.

    http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm

    +
    0 Votes
    jenl2881

    We will try it, but now 5 people are getting the same error.

    +
    0 Votes
    jenl2881

    Our whole office has Office 2007, so compatibility is not the issue.

    +
    0 Votes
    ken

    I had a very similar error with a Microsoft Works client. An XP update about 2 weeks ago gave this error in the Works spreadsheet. They added a patch to fix the Works issue. Might be the same. Do a manual update and choose "custom".

    +
    0 Votes
    jenl2881

    no updates are available. We check regularly. Could this be an issue with the Office SP1 update? The files were going slow after the upgrade, though, and still after the sp1 install.

    +
    0 Votes
    tangoboy98

    http://support.microsoft.com/kb/292471

    This behavior can occur if you define names that indirectly refer to other nested names that are more than 20 levels deep. When you add or use a name that exceeds that level of indirection in a formula, you receive this error message. You also receive this error message when you delete a name that is referenced by more than 20 levels of defined names

    +
    0 Votes
    tangoboy98

    http://support.microsoft.com/kb/292471

    This behavior can occur if you define names that indirectly refer to other nested names that are more than 20 levels deep. When you add or use a name that exceeds that level of indirection in a formula, you receive this error message. You also receive this error message when you delete a name that is referenced by more than 20 levels of defined names.

    APPLIES TO

    * Microsoft Office Excel 2007
    * Microsoft Office Excel 2003
    * Microsoft Excel 2002 Standard Edition