Excel 2003 Subtotals - Inner vs outer 1

[MRyerson]

I just got Excel 2003 installed on my computer. I did a simple 2-level subtotal. Some of the inner subtotals are appearing as outer, and vice-versa. This did not happen in 2002.

Is this a bug in 2003 or is there something I need to set (can't imagine what).

 

[KenWright]

Sounds like the following documented bug and there is a hotfix for it:-

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

Try the hotfix first and if no joy there then maybe the following note I found from a newsgroup post will help - make sure you back up the registry first though if you go this route:-

> > I too am having troubles with nested levels. I have tried it
again and again. It used to work so easily(!). I did the same
process, without really having to think about it, last quarter and it
worked fine and easily. I just did an update of Windows XP, and that
may be the problem. I am sorting on 4 columns and sub-totalling those
columns. It appears the first 3 or 4 names sort one way and the rest
sorts another way -- but even that way is not consistent. Very
frustrating, but glad to hear it may not just be me! Using Excel 2003
with Office Professional for Windows XP.
> >
> >
> > "M Wheeler Ithaca NY" wrote:
> >


I got in contact with Microsoft and there is a fix for this that
requires an update to the registry to tell Excel 2003 to use the Excel
97 subtotal method since the new code subtotals incorrectly. I updated
my registry and the subtotaling now works. The registry entry that
needs to be added is:



Add the following registry key to -
HKEY_CURRENT_USER\software\microsoft\office\11\excel\options

Dword = Excel97Subtotals

Value = 1

Be sure to backup the registry before updating.

Regards
Ken...............




----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[MRyerson]

The Registry mod worked.
Thanks!

Marty

P.S. The "thank you" link appears not to be working.

 

[KenWright]

Cheers for trying though, much appreciated.

For anyone else, this is the second reply I've had for this fix (first elsewhere) that has said the registry fix worked for them.

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------