Formatting Sub Totals

On Excel 97, when you subtotal on one column and then subtotal on a second
column, it puts the first group's subtotal below all of the subtotals for the
second column. (this is how most people would expect to see it, a subtotal
after each of the minor groups, then a subtotal for the major group at the
bottom.)

In Excel 2003, it puts a subtotal for each minor group, but the subtotal for
the major group appears on the line before the subtotal for the last of the
minor groups.

Is there anyway to have Excel 2003 subtotals formatted to look like the
Excel 97 formatting?

Thanks.

It's a known problem that should be corrected by installing this hotfix:

http://support.microsoft.com/default.aspx?id=833855

You can visit this page on the Microsoft site, to find out which Office
updates should be installed:

http://office.microsoft.com/en-ca/of...e/default.aspx


KS wrote:
> On Excel 97, when you subtotal on one column and then subtotal on a second
> column, it puts the first group's subtotal below all of the subtotals for the
> second column. (this is how most people would expect to see it, a subtotal
> after each of the minor groups, then a subtotal for the major group at the
> bottom.)
>
> In Excel 2003, it puts a subtotal for each minor group, but the subtotal for
> the major group appears on the line before the subtotal for the last of the
> minor groups.
>
> Is there anyway to have Excel 2003 subtotals formatted to look like the
> Excel 97 formatting?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html