524160 Row Sort Limit in Excel 2013

[goodsignal]

Has anyone else noticed that Excel 2013 64bit will not sort data if there are more than 524160 rows to be sorted?

Nothing here suggests that this would be a limitation, Excel specifications and limits - Excel

My friend who is running Excel 2010 64bit doesn't have this limitation.

The only references to sort limitations that I could find in this forum are these:
http://www.mrexcel.com/forum/excel-questions/191461-sorting-limitation.html
http://www.mrexcel.com/forum/excel-questions/160051-there-limit-sorting.html

A simple test setup is to populate column A with random values from row 1 to 525000. Then fill column B with consecutive integers for visual reference.

Try sorting column A. It won't sort for me until I've deleted data down to 524160 rows.

 

[Bearcat Brew]

Confirmed. I just got 'upgraded' to 2013 and had the same issue. Any work arounds yet? I would hate to think we would have to resort to some sort or recursive sort macro to do this.

 

[Mr John]

Hi
Is there a fix for this , i just came across the same problem. I am using Microsoft Office 2013

 

[Mr John]

Just an update - I used Microsoft Office 13 on a windows 8 machine and i get the Sort limit issue when > 524160 rows to be sorted. When i used a Win7 machine / Excel 2013 the sort worked perfectly.
Is there a setting that may be making the sort limit from occurring or could it be related to the OS ?

 

[Mr John]

The best solution i came up with is sort the excel data using a Python script and transfer the data back into the Excel document