Excel cannot complete this task with available resources

Asked By clintchop 10 points N/A Posted on - 08/04/2011

Hi to all techyv readers, I am posting here a hard time that I encountered. I received  an error when I am on the process of opening  a file in Microsoft Excel.

Microsoft Excel

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

OK

The error message above gives a lot of hard time on me since I need to view my file for a review. All that was said on that error I already checked, regarding the memory installed on my computer and is above the requirements for Microsoft Excel since I am using a 64bit machine, I already scanned the file for some virus attack that might consumed the memory but no virus was found.

Please share some ideas on how can I open this file. Thanks a lot.

• Status: Open
• Question Views: 2425
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by John Corner

Go To Solution

Best Answer

Best Answer

Answered By John Corner 0 points N/A #98014

Excel cannot complete this task with available resources

This kind of error occurs when both of the following conditions are true:

• First is when the Protect and Share Workbook feature is turned on.

• Second is when configuring the Protect and Share Workbook feature where you must type a password in the Password (optional) box that will password protect the workbook.

This error is corrected in Office XP Service Pack 3. To resolve this error try to obtain the latest Service Pack for Microsoft Office XP.

Just turn on the Office update option if you are connected to internet and try downloading latest updates which should solve this problem.

Cheers,

John

About John Corner

Questions
0

Answers
5

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #98016

Excel cannot complete this task with available resources

I’m sorry but the problem here I think doesn’t concern whether Microsoft Excel is compatible with your system or your computer specifications passed the system requirements of Microsoft Excel. The error message points to the current amount of RAM left in the system while you are accessing the file with Microsoft Excel. Even if your system passes the system specifications of Microsoft Excel, probably your system doesn’t have enough RAM left the time you opened the file.

If there are also other applications currently opened together with Microsoft Excel, try closing them and leave only Microsoft Excel running then try opening the file again. If it’s still the same, try restarting your computer. After booting Windows, don’t open any other applications. Open only Microsoft Excel so the application has all the available resources for its use. Try opening the file again and see what happens. If it’s still another failure, try opening the file on a different computer to see if it’s not corrupted or something.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 05/19/2012
• Question Category: MS Excel

Answered By William G Avalos 0 points N/A #98018

Excel cannot complete this task with available resources

Hi Clintchop,

There is another Techyv's post which is addressed your problem. Pay a visit that page and enrich your knowledge with more techniques to resolve this issue.

Cannot open the file with the extension .xlsx with Microsoft Office.

About William G Avalos

Questions
7

Answers
23

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/03/2014
• Question Category: MS Excel