ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Do nested subtotals have an errror in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/55010-do-nested-subtotals-have-errror-excel-2003-a.html)

rlevitas

Do nested subtotals have an errror in Excel 2003
 
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

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



Dave Peterson

Do nested subtotals have an errror in Excel 2003
 
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


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com