subtotals

[Guest]

Just upgraded to 2003 from 2000 and having a little trouble with the subtotal
placement in 2003.

I do my sort and then ask for a subtotal based on sales rep name and then a
subtotal by customer. The trouble I'm having is with the second subtotal.
When subtotaling by customer it skips the line with the subtotal of sales
reps name and puts the customer subtotal below. This wasn't a problem with
2000 what changed?

Example:
customer A xxx
customer A xxx
subtotal customer xxx
customer B xxx
customer B xxx
Subtotal Sales Rep xxxx
Subtotal customer B xxx

the subototal for Customer B should be above the sutotal sales rep.

 

[Dave Peterson]

I don't use xl2003, but 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.