2007: Cannot subtotal data obtained from MS Query

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.
(www.excelbanter.com/showthread.php?t=242276)

This happens when you convert the range to a Table (Ctrl+T or Ctrl+L). A Table cannot be subtotaled. To overcome this problem, try either of the following:
1. Convert the Table back to a Range - Click on any cell inside the Table and in Table Tools (Yellow button at the top) > Design > Tools > Convert to Range > Yes. Now you will be able to convert to a Range
2. Create a pivot table - If you want to let the Table remain, then just create a pivot table. Drag Part number and Description to the row area and quantity to the data area.
(www.merawindows.com/Forums/tabid/324/forumid/90/threadid/45543/scope/posts/Default.aspx)

Bottom line:
Copy then Paste Values to another worksheet