Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Sorting crashes Excel

    Our Principal can't do a custom sort without crashing the computer. Just an A-Z or Z-A sort works fine. Would anyone have a fix for this?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I can see 3 possibilities:

    1. Corrupt Excel file
    2. Corrupt Excel installation
    3. Something wrong with the operating system

    Suggestions for narrowing this down:

    • Copy the file to another PC. If it still causes a crash then the file is corrupt.
    • If it doesn't cause a crash then I'd reinstall Excel - shouldn't be difficult or destructive.
    • If the sort worked on another PC and you are still getting a crash after reinstalling Excel then you've got something more serious on your hands - a virus, a clash with an update or another package, or a corrupt operating system.


    PS Can you say a little more about "crashing the computer" - what exactly happens ? A freeze, a reboot, a blue screen or what ?
    Last edited by MartinM; 2013-11-27 at 06:36.

  3. #3
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,396
    Thanks
    445
    Thanked 404 Times in 376 Posts
    Another thing you could try: Save the file in an older file format, then try to do the sort. The purpose of doing this is to get Excel to do some regeneration and conversion on the file, thereby possibly eliminating the error in the process.

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It crashes on ANY file that she and I have attempted to custom sort--even on a new file with just a few numbers added to do a 'test' sort.
    I have already uninstalled and reinstalled Office 2010.
    By 'crashes', I mean it locks up and won't do anything--although a few times I've waited long enough for it to eventually react to a mouse click or something, then locks up again for a long time, etc.

    I'll try the older file format option next time I'm back at the school.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    In the circumstances you describe it doesn't sound like a corrupt file, but you may as well try the older file format option - nothing to lose

    Talking with chums about this, one said you can get round a similar problem by saving the file as .xlsx so I'd try that too.
    Excel may have a defective add-in - instructions for disabling add-ins are here: http://office.microsoft.com/en-us/ex...010034127.aspx
    I have also read that trying to sort a range which includes data validation can cause Excel to crash.

    If none of the above work, you would seem to be getting into general PC/Windows issues, and the obvious possibilities include:

    A clash with another package - is there anything else running at the same time, and does it happen in Safe Mode ?
    Malware - I'd run a scan with Malwarebytes
    Operating system problems - can you do a repair/install ?

Posting Permissions

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