![]() |
nested subtotals
Hi All,
I have a problem when I try to do nested subtotals. In cases where an inner criteria has only one kind of element to total, the outer subtotal line comes before the inner subtotal line and it messes the whole thing up. I have Excel 2002(10.6789.6735) SP3 and a friend of mine has Excel 2002(10.6501.6626) SP3 and it works fine on his machine. I even built a macro to do this and it messes up on my computer but works fine on his. Is there a way around this? It seems my version of excel is more up to date than his. -Sean |
nested subtotals
Maybe...
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Sean wrote: Hi All, I have a problem when I try to do nested subtotals. In cases where an inner criteria has only one kind of element to total, the outer subtotal line comes before the inner subtotal line and it messes the whole thing up. I have Excel 2002(10.6789.6735) SP3 and a friend of mine has Excel 2002(10.6501.6626) SP3 and it works fine on his machine. I even built a macro to do this and it messes up on my computer but works fine on his. Is there a way around this? It seems my version of excel is more up to date than his. -Sean -- Dave Peterson |
All times are GMT +1. The time now is 04:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com