Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Experienced any problems with nested subtotals using Windows XP | Excel Worksheet Functions | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
nested subtotals | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |