![]() |
#1
|
|||
|
|||
![]()
Hello, good afternoon,
Problem with Excel 2016 My sort in column using Sort option is not working, I tried with numbers, 5,2,1,3,4 and other try with letters, E,B,A,C,D and when using sort option nothing happen. When clicking the option in sort box, the active book close and and other book open mentioning (version 1)[AutoRecevered] For information, I reinstalled Office and got the same problem. Do you have an idea of what happen and how to solve the problem? Thank you |
#2
|
||||
|
||||
![]()
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data. |
#3
|
|||
|
|||
![]() Quote:
Please find attached three file. Small video showing what I did to sort. Excel file with number and text samples before sorting Same file after sorting Regards |
#4
|
||||
|
||||
![]()
Works perfectly with 2010 ( thanks for the video)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
![]()
Hi Pecoflyer,
Sure, sorting my samples must work with any Excel version as it was working last week with my Excel. What I don't understand is why it is not working now. As far as I know, I didn't modify anything justifying this problem? When problem appeared and trying and trying solving it, the only thing I did was reinstalling Office 2016 but sorting problem still appeared reason why I explained it to the forum to get help. Is it an Office problem? A Windows problem? Or????? Regards |
#6
|
|||
|
|||
![]()
To Alansidman and Pecoflyer
I finally reinstalled Windows and Office and it works. I don't know what did happen but it is the only solution I found. It is a bit radical but... Anyway, thanks for your help. Problem solved. Regards |
#7
|
||||
|
||||
![]()
Thanks for sharing the solution
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#8
|
|||
|
|||
![]()
Hello, I am coming with the same problem than before, sort option is not working.
I explain why. When I got the problem I went to my MS account and by mistake I installed Office 2013. Sorting data worked well but opening some file I did with 2016, some charts was not working. Coming back to my MS account, I remembered I bought Office 2016. So I installed Office 2016 but when trying to sort, it didn't work. So again I would appreciate your help to solve my problem. Now sure, it's an Office 2016 problem. But how to solve it? Regards |
![]() |
Tags |
excel 2016, not working, sorting columns |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort by Columns | emvella | Excel | 4 | 02-26-2019 06:18 AM |
![]() |
Manny | Word Tables | 13 | 10-11-2018 11:22 PM |
Tasks Switch to Non-Working Days on Working Calendar | danelloc | Project | 3 | 10-02-2017 12:38 PM |
![]() |
Dsr122076 | Mail Merge | 1 | 12-03-2015 04:19 PM |
![]() |
rkeles | Excel | 6 | 02-04-2012 01:31 PM |