Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals in a list
On my worksheet I have used the 'Create List' command for the data. However,
in this mode, the Subtotals function on the Data menu is greyed out. In order to add subtotals, I have to convert the list to a range. Surely it's possible to add subtotals within a list? What am I missing? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals in a list
If you have a cell in the list selected, you should be able to just click on the
Subtotal icon on the List Toolbar (show that toolbar if you need to). But using ranges (not lists), data|subtotals and autofilters don't work well with each other. That could be why data|subtotal is disabled for Lists. Bagheera wrote: On my worksheet I have used the 'Create List' command for the data. However, in this mode, the Subtotals function on the Data menu is greyed out. In order to add subtotals, I have to convert the list to a range. Surely it's possible to add subtotals within a list? What am I missing? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals in a list
Thanks. Unfortunately, there is no Subtotal icon on my List Toolbar and the
command is still greyed out on the Data menu, whichever cell is selected within the list. I can understand that filters and subtotals might conflict, but if no filter is actually applied to the data, I'm really surprised that I can't add subtotals without removing the list feature. "Dave Peterson" wrote: If you have a cell in the list selected, you should be able to just click on the Subtotal icon on the List Toolbar (show that toolbar if you need to). But using ranges (not lists), data|subtotals and autofilters don't work well with each other. That could be why data|subtotal is disabled for Lists. Bagheera wrote: On my worksheet I have used the 'Create List' command for the data. However, in this mode, the Subtotals function on the Data menu is greyed out. In order to add subtotals, I have to convert the list to a range. Surely it's possible to add subtotals within a list? What am I missing? Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals in a list
You're right. I mispoke.
It's not called subtotal. The icon is called "toggle total row". And as long as I'm not in the list, I can use data|subtotals. Is your workbook shared? I couldn't apply data|subtotals to a range (not the list) when the workbook was shared. Is the worksheet protected? That would cause a problem, too. And to me, Data|List is very similar to List. And I understand why data|subtotals can't be used with that list. The data doesn't consist of a list anymore--it's got the subtotals in it. Bagheera wrote: Thanks. Unfortunately, there is no Subtotal icon on my List Toolbar and the command is still greyed out on the Data menu, whichever cell is selected within the list. I can understand that filters and subtotals might conflict, but if no filter is actually applied to the data, I'm really surprised that I can't add subtotals without removing the list feature. "Dave Peterson" wrote: If you have a cell in the list selected, you should be able to just click on the Subtotal icon on the List Toolbar (show that toolbar if you need to). But using ranges (not lists), data|subtotals and autofilters don't work well with each other. That could be why data|subtotal is disabled for Lists. Bagheera wrote: On my worksheet I have used the 'Create List' command for the data. However, in this mode, the Subtotals function on the Data menu is greyed out. In order to add subtotals, I have to convert the list to a range. Surely it's possible to add subtotals within a list? What am I missing? Thanks. -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals in a list
No, it's neither shared, nor protected. It looks as if lists and subtotals
don't work together. I really like the list functionality that's in Excel 2003, but this is the first time I've found a snag. I imagined it would facilitate all the sorts of things one wants to do with data, but clearly it's not that sophisticated yet. I await the next upgrade! "Dave Peterson" wrote: You're right. I mispoke. It's not called subtotal. The icon is called "toggle total row". And as long as I'm not in the list, I can use data|subtotals. Is your workbook shared? I couldn't apply data|subtotals to a range (not the list) when the workbook was shared. Is the worksheet protected? That would cause a problem, too. And to me, Data|List is very similar to List. And I understand why data|subtotals can't be used with that list. The data doesn't consist of a list anymore--it's got the subtotals in it. Bagheera wrote: Thanks. Unfortunately, there is no Subtotal icon on my List Toolbar and the command is still greyed out on the Data menu, whichever cell is selected within the list. I can understand that filters and subtotals might conflict, but if no filter is actually applied to the data, I'm really surprised that I can't add subtotals without removing the list feature. "Dave Peterson" wrote: If you have a cell in the list selected, you should be able to just click on the Subtotal icon on the List Toolbar (show that toolbar if you need to). But using ranges (not lists), data|subtotals and autofilters don't work well with each other. That could be why data|subtotal is disabled for Lists. Bagheera wrote: On my worksheet I have used the 'Create List' command for the data. However, in this mode, the Subtotals function on the Data menu is greyed out. In order to add subtotals, I have to convert the list to a range. Surely it's possible to add subtotals within a list? What am I missing? Thanks. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals in a list
A list to me means a set of data that is consistently laid out. Each of the
columns represents that same field. Adding subtotals to a list breaks this definition for me--and it looks like it breaks the rule for MS, too. Bagheera wrote: No, it's neither shared, nor protected. It looks as if lists and subtotals don't work together. I really like the list functionality that's in Excel 2003, but this is the first time I've found a snag. I imagined it would facilitate all the sorts of things one wants to do with data, but clearly it's not that sophisticated yet. I await the next upgrade! "Dave Peterson" wrote: You're right. I mispoke. It's not called subtotal. The icon is called "toggle total row". And as long as I'm not in the list, I can use data|subtotals. Is your workbook shared? I couldn't apply data|subtotals to a range (not the list) when the workbook was shared. Is the worksheet protected? That would cause a problem, too. And to me, Data|List is very similar to List. And I understand why data|subtotals can't be used with that list. The data doesn't consist of a list anymore--it's got the subtotals in it. Bagheera wrote: Thanks. Unfortunately, there is no Subtotal icon on my List Toolbar and the command is still greyed out on the Data menu, whichever cell is selected within the list. I can understand that filters and subtotals might conflict, but if no filter is actually applied to the data, I'm really surprised that I can't add subtotals without removing the list feature. "Dave Peterson" wrote: If you have a cell in the list selected, you should be able to just click on the Subtotal icon on the List Toolbar (show that toolbar if you need to). But using ranges (not lists), data|subtotals and autofilters don't work well with each other. That could be why data|subtotal is disabled for Lists. Bagheera wrote: On my worksheet I have used the 'Create List' command for the data. However, in this mode, the Subtotals function on the Data menu is greyed out. In order to add subtotals, I have to convert the list to a range. Surely it's possible to add subtotals within a list? What am I missing? Thanks. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |