Subtotal Bug in Excel 2003
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. |
All times are GMT +1. The time now is 03:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com