subtotals
 

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

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

Vaya con Dios,
Chuck, CABGx3


"dougkissack" wrote in message
...
multi-level subtotals appear out of order...I have not cleared the summary
below data box

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

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