why can't i use the advanced filter on my data

I can't select advanced filter from the data menu. How can I figure out why?

If the workbook is shared, the Advanced Filter command isn't available.
Could that be the problem?

pinta wrote:
> I can't select advanced filter from the data menu. How can I figure out why?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank-you for responding. At first I had the workbook set up so that it was
not shared. My understanding was that I should make it so it was able to be
shared. So I changed it. Either way that I had it I could not select the
Advanced Filter command. Pinta

"Debra Dalgleish" wrote:

> If the workbook is shared, the Advanced Filter command isn't available.
> Could that be the problem?
>
> pinta wrote:
> > I can't select advanced filter from the data menu. How can I figure out why?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>