Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Have Excel 2003. Can not get the Automatic Subtotal in a list function to
work. When I select a range of data (labels) within my table, the menu command Data - - Subtotal is "greyed out". If I select data on the same worksheet, but NOT in the table, I can use the menu command Data --Subtotal. I have reviewed the help topics in Excel and followed each step, but to no avail. My teacher has also tried to get the function to work. Any hints? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Carl,
did you try to use a subtotal in a Pivot table? regards from Brazil Marcelo "Carl501" escreveu: Have Excel 2003. Can not get the Automatic Subtotal in a list function to work. When I select a range of data (labels) within my table, the menu command Data - - Subtotal is "greyed out". If I select data on the same worksheet, but NOT in the table, I can use the menu command Data --Subtotal. I have reviewed the help topics in Excel and followed each step, but to no avail. My teacher has also tried to get the function to work. Any hints? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
subtotal nesting errors new this month | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |