Problem When you create multilevel or nested data subtotals in Microsoft Excel 2002 or Microsoft Office Excel 2003 (with sp1), with subtotals set to appear in the rows that are above the data row, the sub totals appear in the incorrect order or stacked incorrectly and in a few scenarios may exclude Grand Totals.
FixMicrosoft has issued a hotfix to resolve this problem and can be found here:http://support.microsoft.com/kb/831824
However, the hotfix does not resolve the issue for all - it did not for me at least. Another way to resolve this issue is to mend the registry entries. As follows:
#1: go to the following node in the registry HKEY_CURRENT_USER\software\microsoft\office\11\excel\options#2: Create a Dword entry with this name Excel97Subtotals#3: Set its value to 1 (that is fake or behave like Excel97)
Basically, we are asking Office 2003 Excel's subtotals to work like Excel 97's.
If you need the reg file, here it is. Please backup your registry before applying any of the above changes - if in case.
Close Excel and reopen to see results.
caioNagi