Excel cannot complete this task with available resources.... 2010

Posted on 2011-04-24
Medium Priority
Last Modified: 2012-09-06
Ever since I installed office 2010 on my Windows 7 machine I have been receiving the following errors:

"Excel Cannot complete this task with available resources. Choose less date or close other applications."

this is followed by a statement that the file cannot be opened or corrupted and then repeats the message above about 10 times.

This error is all over the web without much resolution.

The error occurs after an excel sheet is already opened and I try to open another one through windows explorer.  The sheets are very small.   there is no data connections or macros in these sheets.

The only work around is to first open another excel then go to open file and locate the file I need to open.   This opens the same file without any problems.   This makes no sense because excel just told me I didn't have enough memory followed by an error message stating the file was corrupt.

This happens on all excel files not specific ones.   It's very frustrating.   I see this documented all over the place with no real solutions.   Most of the answers here seem to point to older versions of Office.   I believe this may be related to office 2010 and windows 7.

Please help.... Excel opening Excel 2
Question by:EnerconIT
LVL 29

Expert Comment

ID: 35456422
Might be time to run a virus scan?

Author Comment

ID: 35456434
It is not a virus.  I am on a well protected network.   The problem (as I said) is documented throughout the web with not specific solutions.   Thanks.
LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 2000 total points
ID: 35456492
Are any add-ins being loaded? If so try turning them off.

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 35456683
It appears there were some obscure COM add-ins loaded.   After removing this cleared up the problem.
I should have checked the Add-ins.

Thanks for your help!

Expert Comment

ID: 38188351
I have the exact same issue.  I've tried opening a safe version of Excel and I do not have any add-ins of any type loaded but I continue to get this error regardless.  I'm using an i7 with 12 GB of ram and this shouldn't be happening.  

Any other suggestions?

Expert Comment

ID: 38374210
Ljpeson - are you running 32-bit or 64-bit OS?  Excel?

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question