subtotals

[Guest]

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

 

[CLR]

This sometimes happens if the data is not sorted prior to running the
subtotal procedure..........

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

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/officeupdate/default.aspx

=======

And someone else posted a registry fix:
http://google.com/groups?&[email protected]
(one line in your browser)

Look at Grant's post.

 

[Guest]

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\excel\options

Dword = Excel97Subtotals

Value = 1

Be sure to back up the registry before updating."