Bored at work? Make some nuz...
DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact | Forum

Multi-level sort used to work in Excel 2003 but not in 2007 with new computer

View: New views
5 Messages — Rating Filter:   Alert me  

Multi-level sort used to work in Excel 2003 but not in 2007 with new computer

by TSA :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

by skybrake :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

by DigDB Support :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

by DigDB Support :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

by skybrake :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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.


Features | Testimonial | Download | Purchase | FAQ | License | Contact | Forum (powered by Nabble's free forum)

Copyright © 2006 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.