Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-18-2019, 09:46 AM
Francois-Spain Francois-Spain is offline Sort option is not working Windows 10 Sort option is not working Office 2016
Novice
Sort option is not working
 
Join Date: Jun 2019
Posts: 7
Francois-Spain is on a distinguished road
Default Sort option is not working

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
Reply With Quote
  #2  
Old 06-19-2019, 03:01 AM
Alansidman's Avatar
Alansidman Alansidman is offline Sort option is not working Windows 10 Sort option is not working Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 06-20-2019, 02:21 AM
Francois-Spain Francois-Spain is offline Sort option is not working Windows 10 Sort option is not working Office 2016
Novice
Sort option is not working
 
Join Date: Jun 2019
Posts: 7
Francois-Spain is on a distinguished road
Default

Quote:
Originally Posted by Alansidman View Post
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.
Hi Alan,
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
Attached Files
File Type: zip Sorting problem.zip (450.3 KB, 7 views)
File Type: xlsx Excel sorting problem before sorting.xlsx (8.6 KB, 7 views)
File Type: xlsx Excel sorting problem after sorting.xlsx (8.6 KB, 6 views)
Reply With Quote
  #4  
Old 06-20-2019, 06:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Sort option is not working Windows 7 64bit Sort option is not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 06-20-2019, 08:04 AM
Francois-Spain Francois-Spain is offline Sort option is not working Windows 10 Sort option is not working Office 2016
Novice
Sort option is not working
 
Join Date: Jun 2019
Posts: 7
Francois-Spain is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 06-21-2019, 02:50 PM
Francois-Spain Francois-Spain is offline Sort option is not working Windows 10 Sort option is not working Office 2016
Novice
Sort option is not working
 
Join Date: Jun 2019
Posts: 7
Francois-Spain is on a distinguished road
Default

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
Reply With Quote
  #7  
Old 06-21-2019, 11:01 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Sort option is not working Windows 7 64bit Sort option is not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #8  
Old 06-27-2019, 11:04 AM
Francois-Spain Francois-Spain is offline Sort option is not working Windows 10 Sort option is not working Office 2016
Novice
Sort option is not working
 
Join Date: Jun 2019
Posts: 7
Francois-Spain is on a distinguished road
Default

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
Reply With Quote
Reply

Tags
excel 2016, not working, sorting columns

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort by Columns emvella Excel 4 02-26-2019 06:18 AM
Sort option is not working Shading option has stopped working 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
Sort option is not working Mail Merge using edit recipient list option not working properly Dsr122076 Mail Merge 1 12-03-2015 04:19 PM
Sort option is not working Sort Data rkeles Excel 6 02-04-2012 01:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft