Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Excel cannot complete this task with available resources error, Excel 2010
Article ID: 2655178 - View products that this article applies to.
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:
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 2007 error: Excel cannot complete this task with available resources.
Excel 2003 error: Excel cannot complete this task with available resources.
Note: Before continuing on to the Resolution methods, ensure you have the latest Office updates installed: Keep Windows up to date with the latest Updates
After you have installed the available updates, check to see if you still have the issue. Continue to the Resolution Methods if you're still having problems.
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 limitsClick here to show information on how to check Excel 2010 limits.
Method 2: Make sure only one instance of Excel is activeClick here to show information on how to check if only one instance of Excel is active.
Method 3: Close all applicationsClick here to show information on how to close all applications.
Method 4: Test Excel in safe modeClick 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: Save as an Excel workbook file if you use relative namesClick here to show information.
Method 7: Change defined names to reference cells directlyClick here to show information.
If the information in this knowledge base article did not help resolve the error in Excel 2010, select one of the following options: