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