After installing SP1 for XL2003 Subtotals show incorrect result

G

Gaurav

Hi,
After installing SP1 for XL2003 subtotals show incorrect results. It works
fine on XL2003 without service pack
 
F

Fredrik Wahlgren

Gaurav said:
Hi,
After installing SP1 for XL2003 subtotals show incorrect results. It works
fine on XL2003 without service pack
Click to expand...

Do you have a minimal example that illustrates the problem?

Best Regards,
Fredrik
 
G

Gaurav

Hi Fredrik,
The example you are asking for is as below
A B C D
Column A Column B Column C Column D
George Monday 22 220
Gillian Tuesday 23 230
Gillian Wednesday 24 240
Gillian Thursday 25 250
Gillian Friday 26 260
Gillian Saturday 27 270
Gillian Sunday 28 280
Gillian Monday 29 290
Gillian Tuesday 30 300
Gillian Wednesday 31 310
Gillian Thursday 32 320
Gillian Friday 33 330
Gillian Saturday 34 340
Gillian Sunday 35 350
Gillian Monday 36 360
There is only one entry for george.

WITHOUT SP1
Column A Column B Column C Column D
George Monday 22 220
Monday Total 220
George Total 220
Gillian Tuesday 23 230
Tuesday Total 230
Gillian Wednesday 24 240
Wednesday Total 240

After installing SP1 following result is displayed

George Monday 22 220
George Total 220
Monday Total 220
Gillian Tuesday 23 230
Tuesday Total 230
Gillian Wednesday 24 240
Wednesday Total 240
 
F

Fredrik Wahlgren

Gaurav said:
Hi Fredrik,
The example you are asking for is as below
A B C D
Column A Column B Column C Column D
George Monday 22 220
Gillian Tuesday 23 230
Gillian Wednesday 24 240
Gillian Thursday 25 250
Gillian Friday 26 260
Gillian Saturday 27 270
Gillian Sunday 28 280
Gillian Monday 29 290
Gillian Tuesday 30 300
Gillian Wednesday 31 310
Gillian Thursday 32 320
Gillian Friday 33 330
Gillian Saturday 34 340
Gillian Sunday 35 350
Gillian Monday 36 360
There is only one entry for george.

WITHOUT SP1
Column A Column B Column C Column D
George Monday 22 220
Monday Total 220
George Total 220
Gillian Tuesday 23 230
Tuesday Total 230
Gillian Wednesday 24 240
Wednesday Total 240

After installing SP1 following result is displayed

George Monday 22 220
George Total 220
Monday Total 220
Gillian Tuesday 23 230
Tuesday Total 230
Gillian Wednesday 24 240
Wednesday Total 240
Click to expand...

I don't see where your subtotals are. Please attach the file.

/Fredrik
 
D

Dave Peterson

To the Original Poster:

Please don't attach the workbook in your response. Most people don't want to
see attachments in this non-binary newsgroup.

Maybe Fredrik would allow you to send him the workbook directly.

Fredrik??
 
F

Fredrik Wahlgren

Dave Peterson said:
To the Original Poster:

Please don't attach the workbook in your response. Most people don't want to
see attachments in this non-binary newsgroup.

Maybe Fredrik would allow you to send him the workbook directly.

Fredrik??
Click to expand...


Yes, that is OK. Just hit Reply rather than Reply Group

/Fredrik
 
Top