| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested subtotals in incorrect order on large worksheets
I have found that the higher level subtotals are in the wrong order on long
spreadsheets. Has anyone else got this problem or solved it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested subtotals in incorrect order on large worksheets
Maybe...
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 'Wyn wrote: I have found that the higher level subtotals are in the wrong order on long spreadsheets. Has anyone else got this problem or solved it? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested subtotals in incorrect order on large worksheets
Unfortunately the hot fix for this problem doesn't work, instead you actually have to go into the registry and manually revert to the code for Excel 97 and Excel 2000
There is a Microsoft article that tells you how to do this. #831824 that you can get by going on line help and typing "Multilevel subtotals are in the wrong position" There also a companion article that tells you how to back up your registry before you try this. Bob Lyons - 434.972.4137 On Friday, February 05, 2010 10:54 AM 'Wyn wrote: I have found that the higher level subtotals are in the wrong order on long spreadsheets. Has anyone else got this problem or solved it? On Friday, February 05, 2010 12:04 PM Dave Peterson wrote: Maybe... Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 'Wyn wrote: -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
| How do I get the correct order for nested subtotals | Excel Discussion (Misc queries) | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
