![]() |
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? |
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