After impoting data into Excel 2007 the subtotals button is grayed out. Two viable workarounds are to right-click in the Table and select Table>Convert to Range (this effectively breaks the link) or import the data as a pivot table. From what I
am reading in the forums this appears to be a knowm issue with tables in Excel 2007.
Is there a permanent solution to this issue....does this occur in Office 2010?
I would think that this would be "by design" and unlikely to change in future versions.
A table is designed to be just that; rather like a table in Access and just as you couldn't insert subtotals within an Access table, so you can't in an Excel table.
Another option is to copy the results of the query and paste as values to another sheet.
You can then add subtotals to the range on the other sheet while keeping the query connection for future refreshes.
Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk
Marked as answer bySally TangTuesday, September 21, 2010 3:27 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.