Problem with Automatic Nested Subtotals in Excel 2003

[Guest]

Subtotalling 2 different Columns in Excel 2000 worked fine. Trying to do it
in 2003 does not work.
Sorted table in order of 1st column and 2nd column using Sort. Then ran
Subtotal for 1st column and everything OK. See Below
2022633 Total 15967.76
2025295 Total 6.2
2029397 Total 34737.97
2032298 Total 729.68
2032589 Total 110.76
2032865 Total 8084.77
2033204 Total 29400.94
2034453 Total 30390.53
2034484 Total 127.04
2034791 Total 17911.82
2034857 Total 7543.06
2034888 Total 20901.69
2034938 Total 4829.3
2035448 Total 4407.4
Grand Total 175148.92


Tried to run Subtotal again selecting 2nd column and unchecking "Replace
Current Subtotalling" and it does subtotal but when you try to then get bact
to the above result (as you could in Excel 2000) it does not work as per
below.
2022633 Total 15967.76
2025295 Total 6.2
02-Oct-04 Total 6.2
23-Oct-04 Total 2550.42
23-Oct-04 Total 729.68
23-Oct-04 Total 95.12
23-Oct-04 Total 31.27
23-Oct-04 Total 9031.4
23-Oct-04 Total 12401.69
23-Oct-04 Total 127.04
23-Oct-04 Total 3941.31
23-Oct-04 Total 1005.59
23-Oct-04 Total 2840.23
23-Oct-04 Total 1047.62
23-Oct-04 Total 1789.34
Grand Total 175148.92

 

[Debra Dalgleish]

It's a known problem that should be corrected by installing this hotfix:

http://support.microsoft.com/default.aspx?id=833855

You can visit this page on the Microsoft site, to find out which Office
updates should be installed:

http://office.microsoft.com/en-ca/officeupdate/default.aspx