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