What I found was that when you make second level subtotal and if you have
single line for the first level subtotal, the position of total screwed up.
Here's the sample
order customer Item Amount
123 ABC I 10
124 ABC II 20
125 BCD I 10
126 XYZ I 10
126 XYZ II 20
127 XYZ I 10

take subtotal by 'customer' then next level subtotal by order (removed
'replace subtotal' check box). Excel shows subtotal for 125 under subtotal
for BCD.

Is this bug or any fix available? I just did all windows update and office
update but still same.

There is a known bug in subtotal, don't know if that's your problem

http://support.microsoft.com/kb/831824/


Regards,

Peo Sjoblom

"GON" wrote:

What I found was that when you make second level subtotal and if you have
single line for the first level subtotal, the position of total screwed up.
Here's the sample
order customer Item Amount
123 ABC I 10
124 ABC II 20
125 BCD I 10
126 XYZ I 10
126 XYZ II 20
127 XYZ I 10

take subtotal by 'customer' then next level subtotal by order (removed
'replace subtotal' check box). Excel shows subtotal for 125 under subtotal
for BCD.

Is this bug or any fix available? I just did all windows update and office
update but still same.

Thank you very much Peo Sjoblom! That was it!

"Peo Sjoblom" wrote:

There is a known bug in subtotal, don't know if that's your problem

http://support.microsoft.com/kb/831824/


Regards,

Peo Sjoblom

"GON" wrote:

What I found was that when you make second level subtotal and if you have
single line for the first level subtotal, the position of total screwed up.
Here's the sample
order customer Item Amount
123 ABC I 10
124 ABC II 20
125 BCD I 10
126 XYZ I 10
126 XYZ II 20
127 XYZ I 10

take subtotal by 'customer' then next level subtotal by order (removed
'replace subtotal' check box). Excel shows subtotal for 125 under subtotal
for BCD.

Is this bug or any fix available? I just did all windows update and office
update but still same.