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