Excel 2010 -Excel cannot complete this task with available resources
Posted
by
Jestep
on Super User
See other posts from Super User
or by Jestep
Published on 2012-09-06T22:12:46Z
Indexed on
2012/12/06
11:11 UTC
Read the original article
Hit count: 202
excel-2010
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.
© Super User or respective owner