If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
inserting an Excel spreadsheet into Word - how to remove gridl | Steve | Tables | 2 | July 17th, 2007 06:30 AM |
why are nested subtotals coming out below outer subtotals? | Darcy Wendland | Worksheet Functions | 0 | January 18th, 2005 08:09 PM |
inserting a Multiple sheet table from excel into word | John | General Discussion | 1 | November 8th, 2004 10:44 PM |
Inserting a Map into Excel like in Excel 97 | pcchic1 | Worksheet Functions | 1 | March 25th, 2004 04:14 PM |
Excel XP Nested If Function Problem | DaffyD® | Worksheet Functions | 2 | March 6th, 2004 06:46 PM |