Home |
Search |
Today's Posts |
#1
|
|||
|
|||
inserting nested subtotals in excel
when inserting nested subtotals in the same excel file the last ones per
outer subtotal are either above or below the outer total, even that I have checked "summary below data" |
#2
|
|||
|
|||
Maybe...
http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
inserting nested subtotals in excel
I have seen this same problem and applied this suggestion. However, this
suggestion doesn't fix the issue. I have been seeing a flurry of issues relating to standard configuration options in excel since upgrading to Office 2003. One difference that I'm seeing in some of the posts I've found online is that we are Using Office 2003 sp2. It sounds like some of these issues were addressed in sp1, but have the possibly moved back with sp2? "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
inserting nested subtotals in excel
I use xl2003 SP2 (currently).
I changed the registry (in plain old xl2003, IIRC) and never had a problem. Cristofski wrote: I have seen this same problem and applied this suggestion. However, this suggestion doesn't fix the issue. I have been seeing a flurry of issues relating to standard configuration options in excel since upgrading to Office 2003. One difference that I'm seeing in some of the posts I've found online is that we are Using Office 2003 sp2. It sounds like some of these issues were addressed in sp1, but have the possibly moved back with sp2? "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
inserting nested subtotals in excel
Awesome! I was about to cry. I have been sorting / unsorting for 2 hours.
I changed the registry and it fixed the problem. Thanks. "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
inserting nested subtotals in excel
Thanks for posting back.
There have been a couple of people in the last few days that tried this and it didn't work. (I have no idea why not. But I'm glad it worked for you.) Jen Briggs wrote: Awesome! I was about to cry. I have been sorting / unsorting for 2 hours. I changed the registry and it fixed the problem. Thanks. "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
inserting nested subtotals in excel
Hi Dave!
At first this didn't work for me, but then I went back into the Registry and double-checked that the number in the "Modify" box was actually '1'. For some reason even though I'd clicked OK when I did it the first time it was '0'. Once this number was '1' it fixed the problem! Thought you might be able to pass that onto other people - maybe that's why it didn't work for them. Thanks so much for your help, saved HEAPS of frustration. Clair "Dave Peterson" wrote: Thanks for posting back. There have been a couple of people in the last few days that tried this and it didn't work. (I have no idea why not. But I'm glad it worked for you.) Jen Briggs wrote: Awesome! I was about to cry. I have been sorting / unsorting for 2 hours. I changed the registry and it fixed the problem. Thanks. "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
inserting nested subtotals in excel
Thanks for posting back.
Clair wrote: Hi Dave! At first this didn't work for me, but then I went back into the Registry and double-checked that the number in the "Modify" box was actually '1'. For some reason even though I'd clicked OK when I did it the first time it was '0'. Once this number was '1' it fixed the problem! Thought you might be able to pass that onto other people - maybe that's why it didn't work for them. Thanks so much for your help, saved HEAPS of frustration. Clair "Dave Peterson" wrote: Thanks for posting back. There have been a couple of people in the last few days that tried this and it didn't work. (I have no idea why not. But I'm glad it worked for you.) Jen Briggs wrote: Awesome! I was about to cry. I have been sorting / unsorting for 2 hours. I changed the registry and it fixed the problem. Thanks. "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Nilroc wrote: when inserting nested subtotals in the same excel file the last ones per outer subtotal are either above or below the outer total, even that I have checked "summary below data" -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Mini-editor for nested IF's in Excel | Excel Discussion (Misc queries) |