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).

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\E xcel\Options\Excel97Subtotals

and setting its value to 1.

--
Jim
"rlevitas" wrote in message
...
|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).

Maybe...

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

rlevitas wrote:

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