View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default Do nested subtotals have an errror in Excel 2003

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