?
Solved

EXCEL 2007 hangs when sorting

Posted on 2009-04-18
6
Medium Priority
?
461 Views
Last Modified: 2012-05-06
I have an Excel 2007 workbook, and whenever I tried to do the sort by selecting all the Excel sheet, I do sorting on column A and column G--but when I click on sort it it just hangs up and nothing come up. All the time, I have to close the Excel from Task Manager. Any help will be appreciated.


<<Question originally written in all upper case as one long sentence. I retitled it, added the Excel Zone, toned down the "shouting" and broke it up into several sentences for clarity.   byundt, Microsoft Office Zone Advisor>>
0
Comment
Question by:power2009
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:GlennHarris
ID: 24175442
close the file;
make a backup of it somewhere;
In excel chose office button open command; in the file open dialog, click the down triangle to the right of the open button and choose open and repair . . .
0
 

Author Comment

by:power2009
ID: 24175977
I tried that but it dont make any difference. when i select all the sheet and click on custom sort and do sorting on 2 colums example coulmn a and g... excel just freez no response...please help...i already attached a file...please help me out...i m doing custom sort on products sheet...
04-2009new1.xls
0
 
LVL 12

Accepted Solution

by:
GlennHarris earned 200 total points
ID: 24176238
it crashed on me too, probably the data in column g
I used the data tab, text to columns command to parse column g to separate columns based on the comma delimiter. I then sorted on column a and then g and still crashed;
I noticed the file opens in compatability mode. I'd suggest you do a save-as excel 2007 then retry it. Also, be patient, i'd wait 1-2 minutes as there is a lot of data and a lot of blanks;
You might also try to sort using data filters (data or home tab, then filter; click on a filter and choose to sort, first by A, then by G - which i'd still parse into separate columns)
hth
0
 

Author Comment

by:power2009
ID: 24178487
i keep patient more then 10 minutes but when u check the the task manager it shows the excel is showing no repond....but i discover one during the repair of excel if i select extract data and convert to values or i select discover data. and after this when i try sort and it works fine...... is it be possible that the formulas or formatting of this excel sheet is stop sort to work on this sheet...

confused////
0
 
LVL 12

Expert Comment

by:GlennHarris
ID: 25158490
Glad to hear it works fine. It's not possible that the formulas or formatting stop sort from working. You should move a copy of the data to a new workbook for backup and to avoid further corruption.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question