excel 2010 32-bit cannot complete this task with available resources. choose less data or close other applications
Wednesday, June 20, 2012 8:47 PMI 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.
Thursday, June 21, 2012 6:09 AM
Thursday, June 21, 2012 7:02 AMModerator
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.
TechNet Community Support
- Marked As Answer by JH_MV Thursday, June 21, 2012 3:10 PM
Thursday, June 21, 2012 3:15 PM#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.