Excel 2003 error: Excel cannot complete this task with available resources.

Article translations Article translations
Article ID: 292471 - View products that this article applies to.
This article was previously published under Q292471
Expand all | Collapse all

On This Page

Symptoms

You receive the following error message:

Excel cannot complete this task with available resources. Choose less data or close other applications.

The error occurs when you:
  • Open or save an Excel workbook
  • Open an Excel workbook that references a relative name from another workbook
  • Use a defined name in a formula in an Excel workbook
  • Define or delete a name in an Excel workbook

Do you get this error in another version of Microsoft Excel?

To view information on how to resolve this error in another version of Microsoft Excel, click the link that matches your Excel version:

Excel 2010 error: Excel cannot complete this task with available resources.
Excel 2007 error: Excel cannot complete this task with available resources.

Resolution

We recommend that you follow the provided methods in this article in order. However, if you had previously tried one of the methods to fix this error and it did not help, you can jump to another method quickly from this list:

Method 1: Check whether you exceed limits

Click here to show information on how to check Excel 2003 limits.

Method 2: Make sure only one instance of Excel is active

Click here to show information on how to check if only instance of Excel is active.

Method 3: Close all applications

Click here to show information on how to close all applications.

Method 4: Test Excel in safe mode

Click here to show information on how to start Excel in safe mode.

Method 5: Turn off the preview pane in Windows Explorer (Windows 7 only)

Click here to show information on how to turn off the preview pane.

Method 6: Open Excel workbooks with relative names in sequence

Click here to show information.

Method 7: Change defined names to reference cells directly

Click here to show information.

References

If the information in this knowledge base article did not help resolve the error in Excel 2003, select one of the following options:

Properties

Article ID: 292471 - Last Review: October 2, 2012 - Revision: 4.0
Applies to
  • Microsoft Office Excel 2003
Keywords: 
kbprb kbsavefile kberrmsg kbpending KB292471

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com