Subtotal Lines in the wrong place Excel 2003

[Guest]

When nesting subtotals in Excel 2003, the subtotal lines are not in the
correct position. Is there a fix or a work around for this problem?

Example:

Craft Code Crew Count
BA Elec 1
BA Elec 1
BA Total 2
Elec Total 2

 

[Frank Kabel]

Hi
AFAIK you should start with the subtotal for the right-most column and
then add the other columns step by step

 

[Guest]

I followed the instructions that I found in another post (see below) and my
problem seems to be fixed. Thanks
----------------------------------------------------------------------------------------
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.