Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtotal function in Excel 2007 (2007)

    It seems that the subtotal command no longer works when you use Microsoft Query to dump out data to Excel. I've dumped data to a table and the subtotal command under the outline group is greyed out. Is there another way to subtotal other than manually or in a pivot table?

    Thanks,

    Christa

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Subtotal function in Excel 2007 (2007)

    I'm not in front of a 2007 machine at the moment to test, but from what I recall reading, you cannot use the subtotals functionality with Tables, and querytables are treated as Tables. You can either convert it back to a normal range or use a pivot table.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Aug 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I simply copy the entire worksheet and paste "values only" and then subtotals work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •