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? |
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 |
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 |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com