I exported a large amount of data from Access to Excel 2007. There are
28,000 rows but only 7 columns. The worksheet has columns out to XFD. When
I try to sort the data, I'm told the "Excel cannot complete the task with
available resources. Chose less data or close other applications". I am
only selecting the 7 columns for sorting, but because there are so many
columns, the task cannot be done.