ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   data subtotals is not working correctly in Excel 2003 (https://www.excelbanter.com/excel-programming/312891-data-subtotals-not-working-correctly-excel-2003-a.html)

Rick@HealthSciences

data subtotals is not working correctly in Excel 2003
 
I was just upgraded to Excel 2003 and have found that nested sub totals are
not working correctly. I did a 2 level sub total and the minor sub total is
outside the major subtotal range. The major sub total adds correctly but
when the upper left summary buttons are clicked sub totals that should be
summarized still display. Has anyone else had this problem?
Rick

Debra Dalgleish

data subtotals is not working correctly in Excel 2003
 
The problem is supposed to be corrected by installing this hotfix:

http://support.microsoft.com/default.aspx?id=833855

You can visit this page on the Microsoft site, to check what Office
updates should be installed:

http://office.microsoft.com/en-ca/of...e/default.aspx


Rick@HealthSciences wrote:
I was just upgraded to Excel 2003 and have found that nested sub totals are
not working correctly. I did a 2 level sub total and the minor sub total is
outside the major subtotal range. The major sub total adds correctly but
when the upper left summary buttons are clicked sub totals that should be
summarized still display. Has anyone else had this problem?
Rick



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 02:57 AM.

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