
|
Multi-level sort used to work in Excel 2003 but not in 2007 with new computer
I have an extremely large worksheet that has almost 21,000 lines in it that I periodically do a multi-level sort on it. On my older Dell Latitude 600 it used to take about 12-15 minutes to do the sort. I just got a new Dell Latitude 620 with a much better processor and 2x the RAM with Excel 2007 and it has now been over 35 minutes and it is still showing the four original bars in the Progress area when it started. Last night I ended up aborting the same sort after 1 1/2 hours. Has anyone else experienced this problem with Office 2007?
|

|
Re: Multi-level sort used to work in Excel 2003 but not in 2007 with new computer
Greetings,
I too work in large data bases, and am experiencing the EXACT same problem, the only difference i that DigDB sorter worked for me for 2 days in MS excell 2007, then started jamming as you described.
Furthermore it seems to have disabled the regular sorters ability to properly sort. It does not jam...but does not sort.
SO I AM STUCK USING FILTERS ....which is not nearly as efficient and im in the middle of the largest job of my work year. Lord I hope we get some help on this one...im afraid to even remove the program for fear of what might happen to my database.
|

|
Re: Multi-level sort used to work in Excel 2003 but not in 2007 with new computer
I tried the multi-level sort in Excel 2007 on a 4-column table with 21000 rows and it's very fast. If you can send us the data you are having problem with the I will take a look.
But with Excel 2007, it has a built-in multi-level sort, which you can use. It should be a better option than DigDB. Right click your table, on the pop-up menu, select "Sort->Custom sort...", then you should be able to find how to do the multi-level sort.
|

|
Re: Multi-level sort used to work in Excel 2003 but not in 2007 with new computer
With Excel 2007, it has a built-in multi-level sort, which you can use. It should be a better option than DigDB. Right click your table, on the pop-up menu, select "Sort->Custom sort...", then you should be able to find how to do the multi-level sort. By the way, the DigDB sorter shouldn't affect your regular sort.
|

|
Re: Multi-level sort used to work in Excel 2003 but not in 2007 with new computer
Greetings,
Nice to know that 07 has it built in, however that still does not explain why DigDB jams up when sorting. Its left me performing a save before trying to do even a single level sort in DigDB for fear that it will jam again ( when it does you must use the task manger to stop the program, or do a reboot and lose unsaved data)
Please dont get me wrong...I sure love this utility regardless, especially multi filter, and s merge table.
The multi filter lets me show/print my boss what they need quickly without haveing to figure out/write formulas , and merge table beats the heck out of the standard access merge I must do 10 times a day to incorperate link columns into my sheets.
|