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

Posted on 2011-04-24
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

    Might be time to run a virus scan?

    Author Comment

    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

    Are any add-ins being loaded? If so try turning them off.


    Author Comment

    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

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    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 how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now