View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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