Hi

You cannot do this because when you get data from an external source, the
output converts to a Table. Once of the limitations of a table is that you
cannot use Data Subtotals. The only option is to convert the table to a
range (and then you will be able to use Data Subtotals) but then you will
lose the data connection with the external data source.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Scotty Tibbs II" <Scotty Tibbs wrote in
message ...
After querying a database and importing the results in an Excel 2007
worksheet, I am unable to use the subtotal command in the Outline Group of
the Data tab. I could do this in Excel 2003, but after the upgrade I no
longer can do this and at the same time keep the query connection to the
database so I can refresh the data.

How can I accomplish keeping my data live (connected to the external
database via Microsoft Query) and at the same time insert subtotals using
the
sub total command in the Outline Group under the Data tab?