Creating Subtotals in Excel 2003

[benishiryo]

Hi, hope u guys can help me out here.

I have these spreadsheets I always have to do 2 subtotals on at work. They look like this:
PERIOD_NAME ACC_DESC DR CR TOTAL
Jul-10 A 20 -20
Jul-10 B 15 15

So, I want a subtotal for Period Name & the Acc Desc. I went to select Data > Subtotals > At each change in: Period Name. After that, I selected Data > Subtotals > At each change in: Acc_Desc. This time, I unchecked the Replace current subtotals.

So the desired result would be this:
PERIOD_NAME ACC_DESC DR CR TOTAL
Jul-10 A 20 -20
A Total -20
Jul-10 B 15 15
B Total 15
Jul-10 Total -5
Grand Total -5

But sometimes, the subtotal of Acc_Desc would come after the Period_Name like this:
PERIOD_NAME ACC_DESC DR CR TOTAL
Jul-10 A 20 -20
A Total -20
Jul-10 B 15 15
Jul-10 Total -5
B Total 15
Grand Total -5

How do you resolve this?

 

[GlennUK]

There's a bug in Excel 2003 in regards to this.

See this thread to see a link to a Hotfix for it, and ( more importantly ) an alternate fix that you will probably need by way of altering the registry.

 

[benishiryo]

hey glenn, thks alot! i didnt see the link & i tried to search the forum but keep gettin logged out. but i went to search for Excel 2003 Subtotal bug. & found this link:
http://support.microsoft.com/kb/831824/en-us

I havent tried, but i suppose i have to d/l this SP1 right?

 

[GlennUK]

Yes, instal SP1, and change the Registry entry.

Sorry the link I posted hasn't come through ... although you seem to have found something very similar.

 

[benishiryo]

thks once again!