Multiple Subtotal levels in Excel 2003
I am unable to create a file showing multiple subtotal levels using Excel
2003. I previously used this function in all versions prior to Excel 2003. I create a file showing physician specialties and physician group names. I would like to be able to subtotal first on the specialty and then on the group within each specialty. In Excel 2003, the last group within each specialty gets "bumped" outside its respective specialty, and I am left with a report that is incorrectly organized. Again, this seems to be a glitch only occurring in Excel 2003. Any help would be greatly appreciated. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Multiple Subtotal levels in Excel 2003
See http://support.microsoft.com/kb/831824/
"Chris Luka" wrote: I am unable to create a file showing multiple subtotal levels using Excel 2003. I previously used this function in all versions prior to Excel 2003. I create a file showing physician specialties and physician group names. I would like to be able to subtotal first on the specialty and then on the group within each specialty. In Excel 2003, the last group within each specialty gets "bumped" outside its respective specialty, and I am left with a report that is incorrectly organized. Again, this seems to be a glitch only occurring in Excel 2003. Any help would be greatly appreciated. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Multiple Subtotal levels in Excel 2003
Thank you - I will follow the remedy steps.
"bpeltzer" wrote: See http://support.microsoft.com/kb/831824/ "Chris Luka" wrote: I am unable to create a file showing multiple subtotal levels using Excel 2003. I previously used this function in all versions prior to Excel 2003. I create a file showing physician specialties and physician group names. I would like to be able to subtotal first on the specialty and then on the group within each specialty. In Excel 2003, the last group within each specialty gets "bumped" outside its respective specialty, and I am left with a report that is incorrectly organized. Again, this seems to be a glitch only occurring in Excel 2003. Any help would be greatly appreciated. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com