View Single Post
  #6   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

That's the reason, it has built in totals (Toggle Total Row) on the list
toolbar and you cannot apply datasubtotal on either filtered or a list
created with this new function. You can convert it as follows

right click in the list and select List Convert to Range

--

Regards,

Peo Sjoblom


"cawhitaker" wrote in message
...
Yes. I have discovered that if I use AutoFilter, the subtotals do not

work.
If I take AutoFilter off, the subtotals will work if I copy the

information
into a different sheet and then type new headings to the columns of
information. It seems to work sporadically. Thanks!

"Peo Sjoblom" wrote:

Did you create this using the list function?

--

Regards,

Peo Sjoblom


"cawhitaker" wrote in message
...
No. The sheet is not protected. Thanks in advance for any help you

can
give.

"Peo Sjoblom" wrote:

Is the sheet protected?

--

Regards,

Peo Sjoblom


"cawhitaker" wrote in message
...
I am trying to use the sub-total feature in Excel 2003. I have

used
it in
previous versions of excel, but in 2003 it is on the menu, but not
available
for use.