![]() |
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). |
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). |
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