Maximum spreadsheet sort limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Morning all,

Can someone tell me if Excel 2000 has a maximum sort limit in terms of
number of rows? The reason I ask is that the spreadsheet we are currently
using is 17000 or so rows and when it is sorted there is still a large number
of rows that appear to be unsorted.

Thanks in advance for any assistance
Paul
 
Paul,

I just did a simple test and loaded 60,000+ rows and sorted them.Looks
perfect to me.

There must be some other factor affecting it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
My guesses.

#1. You're letting excel guess the range and it's omitting rows--if there's an
empty row in your data, excel may not extend the range to include the rows under
it. I like to select my complete range, then sort--I don't give excel a chance
to guess.

#2. Your data isn't what it appears. Common differences are columns that have
numbers--some of them could be numbers (as numbers) and others could be text
(that look like numbers). 123 is different from '123 (single leading
apostrophe).

And one other data problem is leading/trailing/multiple embedded spaces--so it
might look the same, but really isn't.
 
Back
Top