LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.setup
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
In Excel, how do you copy and paste just the subtotals into anoth. mmiazga Excel Discussion (Misc queries) 4 February 13th 05 01:17 AM
PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT MIKE Excel Discussion (Misc queries) 1 January 27th 05 02:40 PM
why are nested subtotals coming out below outer subtotals? Hendy Excel Worksheet Functions 2 January 18th 05 08:09 PM
Mini-editor for nested IF's in Excel Erik Neu Excel Discussion (Misc queries) 3 January 4th 05 11:30 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"