+ Reply to Thread
Results 1 to 21 of 21

Sort stops working with more than 524161 rows

  1. #1
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Sort stops working with more than 524161 rows

    Excel 2013 Sort stopped working with large data. It will work with data up to 524,161 rows (single column). When one more row (cell) is added it will not sort. I have searched for anyone else having this problem and can not find anything. Has anyone ever heard anything about this or experienced this same problem?

    Thank you for any help anyone can offer.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sort stops working with more than 524161 rows

    Hi and welcome to the forum

    I just sorted 1 000 000 (1 million) rows without a problem. What error message are you getting?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    It does not give an error message. It just does not do anything.

  4. #4
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    I have had others in my office sort the file and it sorts just fine. I know I have sorted large files before. It just stopped working. It will sort up-to 524,161 rows but won't work larger than that.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sort stops working with more than 524161 rows

    When someone else sorts it, it is the exact same file on another pc?

  6. #6
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    It is the exact same file.

  7. #7
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    Same file....but another pc.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sort stops working with more than 524161 rows

    hmm so uploading here wont help

    You are using this in an excel version > 2003, correct?

    Try this...
    close excel (maybe reboot as well, just to start "clean")
    open excel
    in A1 enter 1
    A2=2
    highlight and drag down to row 200
    copy that, paste to 201
    repeat to 1 000
    copy A1:A1 000 down to 1 001
    repeat to 10 000
    do this til you have values down to 1 000 000

    Now, try to sort that and see what happens?

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sort stops working with more than 524161 rows

    I just noticed you posted this in "Office 365", is that the version you are using?

  10. #10
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    Yes, I am using 365. I have created a series like you suggested that is how I determined the number of rows it would sort and at what point it doesn't. Some other information of things I have tried. Yesterday I ran an upgrade/repair on Windows 7 Professional. I also uninstalled Microsoft Office. I then downloaded and installed Office again from the 365 Portal. I still have the sort problem after all of that.

    I suspected add-ins could be causing the problem . I have disabled all add-ins. Still have the problem.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sort stops working with more than 524161 rows

    I will push this to other guru's, experts etc, I have not used 365

  12. #12
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Sort stops working with more than 524161 rows

    Hi,

    I have 2013 365 Office. Just created some random letters, 524161 rows and sorted it. Added some more rows and no problem...

    How much memory do you have on your machine? Can you try the Task Manager to get rid of some other running programs and try it again?

    Here is my sample file.. If it will fit as an attach. Darn - file is too big to attach....

    I created a formula of A2 = Char(RandBetween(65,90)&Char(RandBetween(65,90)&Char(RandBetween(65,90)&Char(RandBetween(65,90)
    I then went to A 524161 and put some data in it. Copy A2, Selected from A3 down to data and paste. Formulas all the way down... Sorted using first row as a header.
    That worked great.. Added some more data and still sorted with more rows of data...
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sort stops working with more than 524161 rows

    Thanks for the assist Marvin

  14. #14
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    I have 8gb of memory. I have created random numbers, numbers in a series and words (all different files and mixed together). It will sort anything up-to 524,161 rows. I created 1,033,905 rows and it will not sort. I can take that same data and highlight the first 524,161 rows and it will sort those rows. It will just not sort anything with more than that number of rows. It is almost like the sort function thinks it is an older version of excel or something.

    The only thing I can think of is there is some program/add-in that has caused this. I have disabled all the add-ins and it still does it. I can't think of anything else that could cause such a strange thing.

  15. #15
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Sort stops working with more than 524161 rows

    You select the cells (entire range of cells) and then sort what is selected? Did I read that? Have you tried to select a single cell in the column and sort by that column? What are we doing differently that lets me sort and you not sort?

  16. #16
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    I have tried all of that. If I select a single cell and try to sort it will not sort if the column contains more than the 524161. If I select cells within that column and sort they sort fine. As far as you doing anything different you are not. As I said I can take this same file and put it on another computer and it sorts everything just fine. That is why I am thinking it has to be some program or some add-in that has reset something or screwed something up.

    Even after reloading Offfice it does the same thing. The other thing I may try...just because I don't have any other answers...is new memory. I just thought I would throw it out here first to see if anyone has ever experienced a similar problem.

    Thanks for helping me think thru this!

  17. #17
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Sort stops working with more than 524161 rows

    Does it work if you start Excel in Safe Mode? (hold Ctrl while starting Excel and answer Yes to the prompt)
    Remember what the dormouse said
    Feed your head

  18. #18
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    No it does not work in Safe Mode either.

  19. #19
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Sort stops working with more than 524161 rows

    That would at least seem to rule out an Excel add-in or startup file.

  20. #20
    Registered User
    Join Date
    11-18-2014
    Location
    Castro Valley, CA
    MS-Off Ver
    7 Professional
    Posts
    1

    Re: Sort stops working with more than 524161 rows

    I'm now having the same problem. Was there ever a resolution to this issue?
    Thanks

  21. #21
    Registered User
    Join Date
    05-03-2014
    Location
    Utah
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Sort stops working with more than 524161 rows

    It is resolved. The only problem is I have know idea what fixed it. I recently ran an Office update. Not sure if that was the fix or not.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Complete novece alert! Adding new rows stops formula working.
    By richimpulse in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2013, 05:26 PM
  2. Sort macro not working on hidden rows?!
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2013, 12:33 PM
  3. Working While Statement Stops Working
    By Verbaruab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2011, 05:58 PM
  4. Macro stops working after rows/columns hidden call
    By stefsj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2011, 07:52 PM
  5. [SOLVED] code stops working after X rows.
    By colwyn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2008, 03:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1