I don't use auto select in my games, but manual selecting with the Tab key does not work if units have a move/attack order, are guarding, or are stationed in a city. My guess is, that auto select works the same way. If that is not what you experience, could you be more specific?