Auto Filter Does Not Work

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I am in Excel 2000 and can't get my autofilter to work on my spreadsheet.
The only option available is "advanced filter." Does anybody know why it is
not working?

Thanks.
 
Hi Michelle

Do you have Freeze panes switched on?
I can't remember whether it was after XL2000, or after XL97 when this was
fixed.
Try switching it off.
 
Roger,

Thanks. I tried your suggestion. It didn't work. If I copy the worksheet
into a new spreadsheet and save it, I don't have this issue anymore. Does
anyone else have any suggestions? Thanks.

Michelle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter Problem 2
Filter not showing blanks option 6
Auto-filter selection 1
Excel 2003 1
Auto Filter - Protected sheet/workbook 3
Auto filter 2
Autofilter: Does Not Contain 2
SUBTOTAL not refreshing when using advanced filter 2

Back
Top