Excel Subtotal problem

G

Guest

I just updated a group of users from Excel XP (2002) to Excel 2003, current
service patch. They are running into an issue with Subtotals:

Multilevel subtotals are in the wrong position.

Example. I sort a worksheet by three levels using Data>Sort, then subtotal
three times using Data>Subtotal, the same fields used to sort, the sum
function and do not have the Replace Current Subtotals box checked. On the
previous version of Excel the subtotals were then nested in the correct
order, on the new version some are and some aren’t, the ones that aren’t have
their first total in the second level.


Thanx

Guy M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal out of sequence 1
Subtotal function is greyed-out - can't insert 3
How do I subtotal specific / random rows from a spreadsheet? 1
Subtotaling non-contiguous cells 2
excel subtotal problems 1
subtotal nesting errors new this month 4
Using data, subtotal 1
Subtotals in Excel 2003 1

Top