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