Share via

Sort option doesn't work

Anonymous
2020-08-23T04:03:46+00:00

Hello, 

From some time I can't do any sorting by Sort and Filter button. I recorded macro for this operation:

Sub sort()

    ActiveWorkbook.Worksheets("Arkusz1").Sort.SortFields.Clear

    ActiveWorkbook.Worksheets("Arkusz1").Sort.SortFields.Add2 Key:=Range("D1"), _

        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal

    ActiveWorkbook.Worksheets("Arkusz1").Sort.SortFields.Clear

End Sub 

Sorting in pivot tables works as it should.

Could you help ?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

4 answers

Sort by: Most helpful
  1. Anonymous
    2020-09-14T04:04:23+00:00

    Hi John, 

    Restarting didn't fix the problem. I tried Repair Office from Control Panel but it didn't help. Next installed Microdoft Support and Recovery Assistant but it didn't help as well. 

    Regards,

    ArtSto

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-09-09T05:51:31+00:00

    Hi ArSto,

    Please try to perform an Online repair to Office.

    To do this, please see: https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

    Please let me know how it goes.

    Regards,

    John

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-09-09T04:23:57+00:00

    Hello John, 

    It's not first time, unfortunately. Below screenshot with random data and steps which I do to make sorting. I try to sort from A to Z, but nothing happen. At the end of sheet have info that sort is in progress.

    Regards,

    ArSto

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2020-08-23T05:08:32+00:00

    Hi ArSto,

    I am John, an Independent Advisor and a Microsoft user like you. I'm here to work with you on this issue.

    May I know if this is the first time it happened to your file? Have you tried working on a new workbook? Does that make any difference?

    You can perhaps share a screenshot of your worksheet (make sure to cover any private/sensitive information before uploading it) that shows the data what are you trying to sort. This will help us to understand your issue better, and then provide you with a solution.

    Awaiting for your response.

    Regards,

    John

    Was this answer helpful?

    0 comments No comments