You mean Table as in DataInsert Table?

If a single column Table you can filter and subtotal within the Table

...............or get rid of it.

Right-click anywhere in the Table and TableConvert to Range


Gord Dibben MS Excel MVP

On Thu, 28 Jan 2010 10:29:02 -0800, Denise
wrote:

I would like to be able to use Microsoft Query to import data from a SQL
database into a sheet in Excel 2007 in a raw format, not a table, so I can
subtotal it. I was able to do it once but not since. Everytime I try now it
come in as a table and then the subtotal button is greyed out. Any help in
in answering this mystery is GREATLY appreciated!