Do nested subtotals have an errror in Excel 2003

G

Guest

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals Nightmare in Excel 2003 4
Nested Subtotals in Excel 2002 2
Nested Subtotals in Excel 2003 9
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) 3
Easier nested subtotals in Excel 2
Excel Subtotals 1
Problem with 2 levels of subtotals 3
Original subtotals should not be within nested subtotals in excel 1

Top