ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sort not working - very large file (https://www.excelbanter.com/excel-worksheet-functions/138602-sort-not-working-very-large-file.html)

HelathcompanyHD

Sort not working - very large file
 
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?

Duke Carey

Sort not working - very large file
 
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

"HelathcompanyHD" wrote:

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?



All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com