871 votes140 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
A work around which I found was to make the table an 'editable range' in the review tab and making all of the columns in the table unlocked, other than the columns involving formulas.
Then, when protecting the sheet, ensure that 'Select locked cells' is unticked - this will unfortunately mean that the users will not be able to select or see the formulas but will allow you to sort the table.
(Although there may be a better link/ how to out there!)
Hope this helps anyone still struggling.