Insert subtotal in a query database Excel 2007

[Scotty Tibbs II]

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 Mathur]

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]

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]

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