| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Hangs when working with a large list | Excel Discussion (Misc queries) | |||
| Working with a large file, calculating after every little change | Setting up and Configuration of Excel | |||
| Sort a large file then sum like values... | Excel Discussion (Misc queries) | |||
| Bin and sort a large list of data | Excel Discussion (Misc queries) | |||
| Working with a large group of numbers | Excel Worksheet Functions | |||
Hybrid Mode
