Excel cannot complete this task with available resources

Question

I have a Dell E6430s laptop, with windows 7 core i7 with 32 mgs of memory.  I have Office 2013 and often get the error message: Excel cannot complete this task with available resources.  Choose less data or close other applications.  I can close excel and open the file with no problem.  Anyone have a solution?

Answer 1

Hi,

Since your computer is connected to a network, you may also post the question in the following link for better suggestions:

http://social.technet.microsoft.com/Forums/en/excel/threads

Answer 2

It is on a network at work.  The thing I go back to, is that it will give me the error message, I shut down excel and then I go back in and I can open it just find.  So I find it hard to believe that it is a problem with the file itself.

Answer 3

Hi,

Is your computer connected to a domain or a network?

You may test with a new file and check if it helps to ensure it is not file corruption issue.

In addition to this, if this file is shared and if there is a password set to it, then remove the password and check the results.

Answer 4

Mostly files on the server.  Again, I can exit excel and go back into it without a problem, so I don't think it is the file itself.

Thanks for your help.

Answer 5

Hi John,

It seems like you are facing issue working with the Excel work book.

Does it happen with a particular file or with all the files?

Is this a shared file? If yes, have you set any password?

Create a new file and check if it works. If it helps, then copy the contents of the file to a new file and check if it helps.

Refer the suggestions in the following thread link for similar issue:

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-cannot-complete-this-task-with-available/951f97a5-4450-4585-bec6-86d1113b286b

Note: This is also applicable to Excel 2013.

Let us know the results to help you better.