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.