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.
I've had success (though I don't know about four levels) making the registry
changes described in support.microsoft.com/kb/831824/
quot;Keith Frankquot; wrote:
gt; I have a user who has noticed a problem with multiple subtotals not showing
gt; up properly in Excel after SP2 is applied to Office 2003. Is anyone aware of
gt; a fix for this?
gt; The user's process is to select subtotals on one field, execute and then
gt; select subtotals on a different field without overwriting the existing
gt; subtotals. Each subtotal group should appear in the same order (1,2) for the
gt; entire spreadsheet. After SP2 is applied the subtotals appear in the correct
gt; order for the first three groupings and then change order. Reinstalling
gt; Office without any service packs corrects the problem.
- Jul 16 Mon 2007 20:38
excel subtotal problems
close
全站熱搜
留言列表
發表留言