can't use Subtotal when table is madewit menu ADD, Table.

[Ben]

Hi,

i use excel 2007 (i translate the menu names because i use another
language).
I made a table, typing the row of the fieldnames and all the record. Then,
using menu "ADD" and under Tables, i clicked on Table. So my table was
created at once with the name 'Table1'.

Remark: i noticed that the range referenced by Table1 does not include the
row of the fields.

Now i want to use subtotals (like in version 2003). But the problem is that,
when i click into the table, 'Subtotal' in menu Data is not available.

I made a second table manually without using menu "ADD" and "Table". When i
click in that second table, Subtotal becomes available and i can use it.

Why is that so? Why not with the first table (which offers facilities with
the arrows beside the fieldname, layout ..)

Thanks
Ben

 

[Shane Devenshire]

Hi,

Don't give up, it can be done.

First, in 2003 Lists behave the same way - they don't allow the subtotal
command.

The reason is that the List or Table can be used by other parts of Excel
such as Pivot Tables and Chart to control the source range. But if you could
use the Subtotal command then you would not be able to use the list in these
other situations because there would now be rows (subtotal and grandtotal
rows) which would get included in the pivot tables or charts which would
cause them to return incorrect results.

So apparently Microsoft felt that the other uses for table/lists overruled
the ability to use the subtotal command in the list.

All of that said - you can do what you want - simply create the subtotal
first and then convert it to a table.

 

[Dan]

Thanks

Hi,

Don't give up, it can be done.

First, in 2003 Lists behave the same way - they don't allow the subtotal
command.

The reason is that the List or Table can be used by other parts of Excel
such as Pivot Tables and Chart to control the source range. But if you
could
use the Subtotal command then you would not be able to use the list in
these
other situations because there would now be rows (subtotal and grandtotal
rows) which would get included in the pivot tables or charts which would
cause them to return incorrect results.

So apparently Microsoft felt that the other uses for table/lists overruled
the ability to use the subtotal command in the list.

All of that said - you can do what you want - simply create the subtotal
first and then convert it to a table.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Shane Devenshire]

Your welcome! and thanks for the feedback.


Cheers,
Shane Devenshire