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.
|