I am running Excel 2003 SP3.

When calculating a subtotal on location, then by salesperson, excel is
inserting the subtotal for the salesperson after the location. I would
expect to see the following:

Salesperson 1 subtotal
Salesperson 2 subtotal
Location subtotal

What I am seeing is:

Location subtotal
Salesperson 2 subtotal
Salesperson 2 subtotal

Does anyone know why this is happening.