Subtotal fails

[Guest]

Hello,

I have noticed an error when I do a subtotal with two breaks (do the
subtotal twice on the same data).

I have narrowed it down and have a book that the error can be reproduced and
since it is very hard to explain in text I'd really like to send a copy of my
workbook.

But here is my explanation in text:

I have a sheet with following data:

B1 B2 S1 S2 S3 S4 S5 S6 S7 S8 S9 S10
A B 1 1 1 1 1 1 1 1 1 1
A B 1 1 1 1 1 1 1 1 1 1
C D 1 1 1 1 1 1 1 1 1 1

I select the cells and choose subtotals on every change in B1 and do a
subtotal on S1-S10

This works OK.
Then I do a subtotal again on every change in B2, same subtotal columns.

If you followed my example you will see that row 7 and row 8 is switched
like this:
B1 B2 S1 S2 S3 S4 S5 S6 S7 S8 S9 S10
A B 1 1 1 1 1 1 1 1 1 1
A B 1 1 1 1 1 1 1 1 1 1
Total B 2 2 2 2 2 2 2 2 2 2
Total A 2 2 2 2 2 2 2 2 2 2
C D 1 1 1 1 1 1 1 1 1 1
Total C 2 2 2 2 2 2 2 2 2 2
Total D 2 2 2 2 2 2 2 2 2 2
Total 3 3 3 3 3 3 3 3 3 3


If you test this, ensure you have the data exactly as above since it will
work in some cases...

Please help, this is a critical for me.

Thanks in advance
/Nicke

 

[Guest]

Nicke, send a copy to wcpfister(removethis)@gmail(removethis).com.

Bill

 

[Dave Peterson]

Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;831824

 

[Guest]

Thanks for your answer but I know about this article. The registry hack they
suggests has saved me from another issue.

I was suprised when a customer got this error and the registry hack didn't
solve the problem.

 

[Dave Peterson]

It fixed it for me.

I'd do it again--can you watch them to make sure they do it ok.

 

[Guest]

The problem is that I can reproduce the problem. (as my example). It doesn't
matter how the registry is set.

 

[Dave Peterson]

Sorry,

I don't have another suggestion.

The problem is that I can reproduce the problem. (as my example). It doesn't
matter how the registry is set.