Maximum spreadsheet sort limit

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)


"Paul Townsend" <[email protected]> wrote in message
news:[email protected]...
> 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

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.

Paul Townsend wrote:
>
> 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

--

Dave Peterson