Sorting Subtotals in 2007

[bildar76]

I have just upgraded my office to 2007. In the excel 2003 I was able to have a list of customers and subtotal it. Then after I subtotal it then I need to sort it by the subtotals. It would perfectly. Now with 2007 after I do the subtotals it works fine until I go to sort it. Then it tries to remove the subtotals and sort it. It gives me this message.

"This removes the subtotals and sorts again. If you want to sort the subtotaled groups, choose the Cancel buttons: then collapse the outline and try again."

I have tried this an nothing will work. I take the exact same sheet to 2003 and it works fine. Is there a trick to doing this or what are my options.
Thanks

[bildar76]

Anyone have any ideas???