Insert subtotal in a query database Excel 2007

  • Thread starter Thread starter Scotty Tibbs II
  • Start date Start date
S

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?
 
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
 
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
 
Back
Top