Sort not working - very large file

H

HelathcompanyHD

I am trying to sort a file with many columns, it is a 10 M file. If I break
the file in half, I can sort half and then sort the other half, but I cannot
sort the entire file. Is there a limit that messes up sorting that I haven't
found?
 
D

Duke Carey

There may be an issue with RAM. witha file that large.

If you have MS Access I'd recommend that you either import the data into
Access, or use Access to link to the Excle file, and sort within Access. You
won't have any memory limitations there
 
Top