ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Subtotals do not group (https://www.excelbanter.com/excel-worksheet-functions/62510-subtotals-do-not-group.html)

Tom Hayakawa

Subtotals do not group
 
Recently I've encountered instances where, when I perform the Subtotal
function, the results do not automatically group on the left margin. I still
get the Subtotal lines inserted properly, but there is no grouping. Is it
possible I don't have enough memory, or is there something going on with
Excel that I need to change? Thanks in advance.

Tom Hayakawa

Subtotals do not group
 
Additional information:

This is Excel 2K and was recently upgraded. I also find that by copying a
worksheet containing a subtotal that was created on the old version, I can
now do subtotals on new data and get the groupings to work. Digging through
the Microsoft Support pages I found a tip (831824) about changing the
registry to get Excel 2000 functionality back on Excel 2002 and Excel 2003.
Could this be the "problem"? Am I the victim of a new "function"?


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com