Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Getting this error when trying to sort a document (Excel cannot complete this task with available resources). Document isn't particularly large, about 4,000 lines. Can't seem to figure out why this would start on this. I can sort this same file fine on everything back to Excel 2000 on older crappy computers.

Computer is running Win 7 x64, 16 Gb RAM, and another 16 Gb of virtual. There's no possible way that all of the memory is actually getting exhausted when I can perform this on an older XP machine with 512 Mb of RAM, unless 2010's memory usage is inconceivably poorly designed.

I found a few posts on forums stating that there might be a security update related bug. Any suggestions would be appreciated.

share|improve this question
    
Have you tried to look for SP's / updates for the Excel? –  Matan Eldan Sep 6 '12 at 22:25
    
Yeah, double checked it's fully updated. No errors in the Windows logs either. Possible it's a corrupt installation, or there is some other problem. This computer was setup from scratch about a week ago, so I don't think there is a hardware or OS issue. –  Jestep Sep 7 '12 at 13:52
    
Well... in that case, I'll just recommend you to re-install your copy of Excel. –  Matan Eldan Sep 8 '12 at 22:13
add comment

3 Answers

Must be a common problem because there is a KB article for it. This contains 7 methods to help you resolve this issue.

Excel cannot complete this task with available resources error, Excel 2010

share|improve this answer
    
Most of those tips seem like they shouldn't matter for someone with a file that small and a computer with that much memory. –  Michael McGowan Sep 11 '12 at 19:24
    
@MichaelMcGowan Things are not always what they seem, especially when it comes to computers. If one of those methods fix the problem, then it matters. –  CharlieRB Sep 11 '12 at 19:38
add comment

For me it was my clipboard manager (Ditto). I'm not sure why, since Ditto can handle large clips, but I had a suspicion it might be that and as soon as I exited Ditto, Excel could copy it fine. (Excel does very strange things for copy and paste.)

share|improve this answer
add comment

This is the most annoying error of Office 2010. I was also suffered it when start using Excel 2007. To fix this issue I just applied Hotfix as mentioned on http://support.iyogi.com/microsoft/microsoft-excel/how-to-fix-the-error-excel-cannot-complete-this-task-with-available-resources-choose-less-data-or-close-other-applications.html These Hotfixes can be applied for Office Home and Business 2010 Office Home and Student 2010 Office Professional 2010 Office Professional Plus 2010 Office Standard 2010 Office Starter 2010 Access 2010 Excel 2010 Ppt 2010 Project Professional 2010 Project Server 2010 Project Standard 2010 SharePoint Foundation 2010 SharePoint Server 2010 and can be accessed from http://support.microsoft.com/kb/2712235

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.