View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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