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?

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?

Ashish:

I understand what you are telling me and I agree. However, I was able to do
this in Excel 2003. Was this feature removed in Excel 2007? I am trying to
avoid changing the table to a range in order to keep the data connection
"live".

Scotty Tibbs II

"Ashish Mathur" wrote:

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?

Hi,

Not usre how it was in Excel 2003. I run into the same problem in Excel
2007.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Scotty Tibbs II" wrote in message
...
Ashish:

I understand what you are telling me and I agree. However, I was able to
do
this in Excel 2003. Was this feature removed in Excel 2007? I am trying
to
avoid changing the table to a range in order to keep the data connection
"live".

Scotty Tibbs II

"Ashish Mathur" wrote:

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?