View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
denise denise is offline
external usenet poster
 
Posts: 112
Default Import external data into Excel 2007 so I can subtotal it

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!