Thread: Sorting failure
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Sorting failure

xl2007 supports up to a million rows.

xl2003 and below only allow 64k rows, so sorting more than that isn't built into
excel.


ela wrote:

I searched by Google about whether Excel can sort more than 65535 rows but
the result is confusing. Does anybody encounter the same situation as mine
that some rows remain unsort when you are sorting a large table with, say,
100,000 rows?


--

Dave Peterson