Why doesn't nesting subtotals work in 2003 version?
Has anyone else had trouble with nesting subtotals? When I subtotal the
first time it works fine. When I do the second subtotal, excel puts some of the total below the first sub and some above...so the groupings are all off. Help! I used to use this function all the time, and manually takes too much time. |
Excel 2003 has a known subtotal bug
http://support.microsoft.com/kb/831824/ Regards, Peo Sjoblom "Rebecca" wrote: Has anyone else had trouble with nesting subtotals? When I subtotal the first time it works fine. When I do the second subtotal, excel puts some of the total below the first sub and some above...so the groupings are all off. Help! I used to use this function all the time, and manually takes too much time. |
Is there any work-around or do you have suggestions for another solution?
Thanks. "Peo Sjoblom" wrote: Excel 2003 has a known subtotal bug http://support.microsoft.com/kb/831824/ Regards, Peo Sjoblom "Rebecca" wrote: Has anyone else had trouble with nesting subtotals? When I subtotal the first time it works fine. When I do the second subtotal, excel puts some of the total below the first sub and some above...so the groupings are all off. Help! I used to use this function all the time, and manually takes too much time. |
I gave you the only solution there is
-- Regards, Peo Sjoblom (No private emails please) "Rebecca" wrote in message ... Is there any work-around or do you have suggestions for another solution? Thanks. "Peo Sjoblom" wrote: Excel 2003 has a known subtotal bug http://support.microsoft.com/kb/831824/ Regards, Peo Sjoblom "Rebecca" wrote: Has anyone else had trouble with nesting subtotals? When I subtotal the first time it works fine. When I do the second subtotal, excel puts some of the total below the first sub and some above...so the groupings are all off. Help! I used to use this function all the time, and manually takes too much time. |
All times are GMT +1. The time now is 08:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com