Excel 2007 - Subtotals for data from MSQuery

[amrog]

I am using Excel 2007.
I use MSQuery to connect using ODBC to an Oracle server and get data into table.

I am trying to use subtotals, but it seems not working with data from table!!

Can anyone support how to overcome this issue or use a VB macro to dynamicly calculates subtotals as table is refreshed?

 

[SkipVought]

Hi,

Forget subtotals IN the query.

Use Excel's Subtotal feature on the QueryTable resultset.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}