Forum Discussion
Sort in alphabetical order; sub total groups
One more thing worth checking that Ryan didn't mention, since a reinstall wouldn't fix it: merged cells. Excel won't sort a column that contains merged cells, and a sort click can just sit there doing nothing, which matches what you're describing. Merged cells are easy to miss too, especially in a header row or a title area above the data.
The quick way to hunt them down in desktop Excel is Home, Find and Select, Find, then Format, Alignment, tick Merge cells, and Find All. That lists every merged cell on the sheet. Unmerge the ones in or above your data range, then try the sort again. If the merged cells are there for layout, like a title across the top, move the title out of the sort range rather than unmerging it.
Given the reinstall didn't help, it's almost certainly something in the sheet itself, so the table, protection and merged-cell checks between Ryan's reply and this one should pin it down.