Grant's post contained the fix for me. His post is as follows.....
"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 back up the registry before updating."

"Dave Peterson" wrote:

maybe.....

Debra Dalgleish has posted this:

=======

The problem may be corrected by installing this hotfix:

http://support.microsoft.com/default.aspx?id=833855

You can visit this page on the Microsoft site, to check which Office
updates should be installed:

http://office.microsoft.com/en-ca/of...e/default.aspx

=======

And someone else posted a registry fix:
http://google.com/groups?&threadm=f6...ing.google.com
(one line in your browser)

Look at Grant's post.


dougkissack wrote:

multi-level subtotals appear out of order...I have not cleared the summary
below data box

--

Dave Peterson