After installing SP1 for XL2003 Subtotals show incorrect result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
After installing SP1 for XL2003 subtotals show incorrect results. It works
fine on XL2003 without service pack
 
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
 
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
 
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
 
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??
 
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
 
You must log in or register to reply here.

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

GETPIVOTDATA #REF! error XL2003/2010 1
Getting Text data using the Data - Subtotal feature 1
subtotal copy and paste 3
set excel 2003 as default excel application 2
XL2003 to XL2000 code converson 2
2 level subtotal result weird 2
Another Custom Format 2
subtotal titles 1

Back
Top