D
dougkissack
multi-level subtotals appear out of order...I have not cleared the summary
below data box
below data box
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
This sometimes happens if the data is not sorted prior to running the
subtotal procedure..........
Vaya con Dios,
Chuck, CABGx3
subtotal procedure..........
Vaya con Dios,
Chuck, CABGx3
D
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.
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.
D
dougkissack
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."
"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."