Sign in
 
Home20132010Other VersionsLibraryForumsGallery

none
excel 2010 32-bit cannot complete this task with available resources. choose less data or close other applications

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have a 200,000-row (9 MB) spreadsheet which, when I try to sort on one column in excel 2010 hangs excel and says 'excel cannot complete this task with available resources. choose less data or close other applications'. I am running 64-bit windows 7 but excel 2010 is 32-bit. I was all set to go to 64-bit excel 2010 but it seems that not all add-ins (which ones?) work with it. Excel 2007 (32-bit) running on an xp machine (with less memory) has no problem sorting this file.
    Wednesday, June 20, 2012 8:47 PM
    |

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi,

    Here are some suggestions:

    1. Just to check whether you have installed the KB2597166, if you have, uninstalled it and check the issue.

    2. Sometimes the preview pane in Windows Explorer may cause this message, particularly if you have just attached an Excel sheet in Outlook or opened the file directly from Windows Explorer. If you turn off the preview pane, it stops these messages.

    3. Uninstalled Windows Live Essentials and Microsoft Outlook Social Connector for Live Messenger

    Just try method 1 first, if it is not helpful, then try 2, then 3.

    Jaynet Zhang

    TechNet Community Support

    • Marked as answer by JH_MV Thursday, June 21, 2012 3:10 PM
    Thursday, June 21, 2012 7:02 AM
    |
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jh,

    What happens if you copy the data and paste-special-values it to a fresh workbook, can you sort it there?

    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
    Thursday, June 21, 2012 6:09 AM
    |
  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi,

    Here are some suggestions:

    1. Just to check whether you have installed the KB2597166, if you have, uninstalled it and check the issue.

    2. Sometimes the preview pane in Windows Explorer may cause this message, particularly if you have just attached an Excel sheet in Outlook or opened the file directly from Windows Explorer. If you turn off the preview pane, it stops these messages.

    3. Uninstalled Windows Live Essentials and Microsoft Outlook Social Connector for Live Messenger

    Just try method 1 first, if it is not helpful, then try 2, then 3.

    Jaynet Zhang

    TechNet Community Support

    • Marked as answer by JH_MV Thursday, June 21, 2012 3:10 PM
    Thursday, June 21, 2012 7:02 AM
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    #1 did the job. On the 20th I uninstalled all of the office updates of 6/19 and that fixed a problem where it was complaining about a file being corrupted (or the like). I noticed just after that the updates of 6/20 arrived. It looks like the problem with resources was copied from updates of 6/19 to those of 6/20. Thanks very much.
    Thursday, June 21, 2012 3:15 PM
    |