Nested Subtotals in Excel 2003 -Solution
 

Hmmm, we have this problem with a fully-patched Excel 2003 unit, and the
registry fix below did not seem to help. Any one have any other suggestions
(MS?)

Thanks,
-Gantry

"Ken Carter" wrote:

Thanks to Grant above for the solution that solved my original problem.

His answer was:

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\exc el\options

Dword = Excel97Subtotals

Value = 1

Be sure to backup the registry before updating.

It's pretty rare that an actual MS employee will respond to questions here.

It's mostly just people helping people (not saying that MS employees aren't
people <bg).

But I'd read the KB article and double check that you did it correctly.

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824


GantryG wrote:

Hmmm, we have this problem with a fully-patched Excel 2003 unit, and the
registry fix below did not seem to help. Any one have any other suggestions
(MS?)

Thanks,
-Gantry

"Ken Carter" wrote:

Thanks to Grant above for the solution that solved my original problem.

His answer was:

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\exc el\options

Dword = Excel97Subtotals

Value = 1

Be sure to backup the registry before updating.


--

Dave Peterson