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.
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.
Is the sheet protected?
--
Regards,
Peo Sjoblom
"cawhitaker" <[email protected]> wrote in message
news:[email protected]...
> 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.
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>
Did you create this using the list function?
--
Regards,
Peo Sjoblom
"cawhitaker" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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.
> > >
> > >
> > >
>
>
>
That's the reason, it has built in totals (Toggle Total Row) on the list
toolbar and you cannot apply data>subtotal 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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.
> > > >
> > > >
> > > >
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks