When using ‘table’ as the display mode in Drupal views module, I noticed the settings I set under ‘sort’ were being ignored.

If you click the icon next to ‘table’ you open the configuration box. Here you can choose the order and there’s also a tickbox that is set to override your ‘sort’ settings it’s ticked as default, which isn’t very helpful, but once you know where it is, you’re back in control.