ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel subtotal problems (https://www.excelbanter.com/excel-worksheet-functions/77331-excel-subtotal-problems.html)

Keith Frank

excel subtotal problems
 
I have a user who has noticed a problem with multiple subtotals not showing
up properly in Excel after SP2 is applied to Office 2003. Is anyone aware of
a fix for this?
The user's process is to select subtotals on one field, execute and then
select subtotals on a different field without overwriting the existing
subtotals. Each subtotal group should appear in the same order (1,2) for the
entire spreadsheet. After SP2 is applied the subtotals appear in the correct
order for the first three groupings and then change order. Reinstalling
Office without any service packs corrects the problem.

bpeltzer

excel subtotal problems
 
I've had success (though I don't know about four levels) making the registry
changes described in http://support.microsoft.com/kb/831824/

"Keith Frank" wrote:

I have a user who has noticed a problem with multiple subtotals not showing
up properly in Excel after SP2 is applied to Office 2003. Is anyone aware of
a fix for this?
The user's process is to select subtotals on one field, execute and then
select subtotals on a different field without overwriting the existing
subtotals. Each subtotal group should appear in the same order (1,2) for the
entire spreadsheet. After SP2 is applied the subtotals appear in the correct
order for the first three groupings and then change order. Reinstalling
Office without any service packs corrects the problem.



All times are GMT +1. The time now is 08:18 PM.

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