Subtotals grayed out in Excel 2007


  • 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?


    Monday, September 20, 2010 3:51 AM


  • 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.
    • Marked as answer by Sally Tang Tuesday, September 21, 2010 3:27 AM
    Monday, September 20, 2010 10:14 AM