Do nested subtotals have an errror in Excel 2003

[rlevitas]

I cannot nest subtotals in Excel 2003 without weird results I am summarizing
a report by carrier, State, and Plan. Using the same tecnique as in previous
versions, the nesting does not work. The second set of sub-totals ( State)
seems to ignore the first level (Carrier).

 

[Jim Rech]

Excel 2003 was changed to handle subtotaling in a different way. You should
get the former behavior by adding this dword key to your registry:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\Excel97Subtotals

and setting its value to 1.

--
Jim
|I cannot nest subtotals in Excel 2003 without weird results I am
summarizing
| a report by carrier, State, and Plan. Using the same tecnique as in
previous
| versions, the nesting does not work. The second set of sub-totals ( State)
| seems to ignore the first level (Carrier).

 

[Dave Peterson]

Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;831824