Hi Alane
i use this feature extensively and have found no difference in its behaviour
between any of the versions, however it is important that the data is sorted
in the same categories and order that it is to be subtotalled,
e.g. i have a worksheet that has region, state, department information on it
and i want to get the subtotal of sales by each of these categories - in the
data / sort box i first choose region, then in the next section i choose
state and in the third i choose department - then i choose data / subtotals
and choose at each change in 'region' , tick the sales box & ensure that
summary below data is checked - click OK, then i choose data / subtotals,
choose at each change in 'state', tick the sales box, UNTICK replace current
subtotals, ensure summary below data is checked, click Ok and finally i
choose data / subtotals, choose at each change in 'department', ensure the
sales box is checked, ensure the replace current subtotals is not checked,
ensure summary below data is checked and click OK and it works fine.
is there anything different that you do to what i've outlined above?
Cheers
JulieD
