4

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.

Jestep
  • 385

2 Answers2

1

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.)

Paul
  • 361
0

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

CharlieRB
  • 23,021
  • 6
  • 60
  • 107