Subtotal Quirkiness

[RLanning]

Running Excel 2003 with all the latest updates.

We have uncovered a problem with subtotals with nested
subtotals. If we create a worksheet that has a "subtotal
within a subtotal", the last group's nested subtotal is
outside the last group's subtotal.

Example:

GROUP NEST1 VALUEA VALUEB
A 1
A 1
B 2
B 2
B 3
C 4
C 4
C 5
D 6
D 6

My subtotals should be:

1
A
2
3
B
4
5
C
6
D

and then two grand total lines...

....what I'm getting is:

1
A
2
3
B
4
5
C
D
6

....and two grand total lines.

 

[plasticman]

I am having the same problem and I'm surprised a bigger
deal hasn't been made of it, as it forces me to go to
another machine running Excel 2000 in order to get my
reports correct. In an AR aging report, I need to
collapse the groupings down to salesperson, with
subtotals by customer embedded under each salesperson.
Because of this problem the collapsing does not work
correctly.

Anyone know of a fix?