excel crashes when sorting

Question

I have a brand new laptop and office recently installed (windows 7). Everything is fine except when I sort in Excel, Excel crashes and windows 7 creates a recovered version. This is a real pain at I need to sort many times a day. Can anyone help please. Thanks

Answer 1

Actually - after some more research I found another post that recommended a File-SaveAs to XLSX format.  My workbook was still XLS.  This worked for me.

Answer 2

Hi everyone,

I am using Office 2013.

In my particular case, I have narrowed the "crash on sort" down to this:

• Some rows are grouped
• Filtering as been applied to one of the columns

Note that BOTH grouping and filtering need to have been applied.  If either isn't there, i.e. I either ungroup all the rows, OR none of the columns have filtering, then sorting works perfectly.

I have an extremely simple test file (8 columns, 11 rows) .  It has no macros.  But with the above criteria, the crash is 100%.

I have tried disabling add-ins.  I have tried the registry trick.  I have tried turning filtering on and off in the headers.  No go.

Is this a known issue?  Is Microsoft aware?  Is there a workaround?

I have never tried to interact directly with support.  I'd love to send my test file to someone, but I'm not sure how to go about that in a way that someone at MS will take notice.

Suggestions, anyone?

Thanks!

Answer 3

This works for me...  I select the first cell in my header, turn off the filter and then right back on. (two clicks on the ribbon filter icon)  This can be done in VBA of course too if you're populating tables using code.  Just reset the filter at the end.  Works for me on XLSM and XLSB version 2010.

Answer 4

Deleting the registry setting sorted my issue with sorting

Run > regedit > HKEY_CURRENT_USER > SOFTWARE > MICROSOFT > OFFICE > 14.0

       Right click Excel and rename it to Excel.old then exit and reopen Excel

http://www.tek-tips.com/viewthread.cfm?qid=1643850

Answer 5

Hi, try this solution given before

Hi,

Here are some options to try....

Running Microsoft Office Diagnostics within Excel

•Click the Microsoft Office button

•Click on the Excel Options button to bring up the Excel Options dialog box

•Click on the Resources button in the left hand pane

•Click on the Diagnose button in the right hand pane

•Click Continue

•Click Run Diagnostics

You may also try to disable the "COM add-in for Excel".

•Click the Microsoft Office Button , click Excel Options, and then click Add-Ins.

•In the Add-ins box, identify the add-in that you want to disable.

•Select the Add-in type in the Manage box and then click Go.

•Clear the check box for the Add-in that you want disable and then click OK.

Also please check this hotfix: http://support.microsoft.com/kb/942382

Hope it does help.