automatic subtotal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl501 - 20 Jun 2006 16:02 GMT

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 to this Message

Marcelo - 20 Jun 2006 21:35 GMT

Hi Carl,

did you try to use a subtotal in a Pivot table?

regards from Brazil
Marcelo

> Have Excel 2003. Can not get the Automatic Subtotal in a list function to
> work.
[quoted text clipped - 3 lines]
> 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 to this Message