Advanced Filtering is Unavailable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to remove duplicate rows from an excel worksheet, but Advanced
Filtering is grayed out and not available. Is there a setting I need to
change to make this command available
 
Is the workbook shared? If it is, the Advanced Filter feature won't be
available. For more information on shared workbooks, look in Excel's
Help, under the topic 'Features that are unavailable in shared workbooks'
 
Thanks Debra - Yes, the workbook was shared. I "un-shared" it and I was able
to use advanced filtering to fix my duplication problem.
 
You're welcome! Thanks for letting me know how you fixed the problem.
 
You must log in or register to reply here.

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

reference cell from advanced filter 3
Auto Filter is unavailable - grayed out 1
Which is the best MBOX Converter Tool different formats conversion? 5
Complex criteria in advanced filters 2
How do I clear an Advanced Filter 1
Advanced Filter - Exclude two criteria in separate columns 2
remove duplicate rows but keeping all columns 3
need help on either doing a loop and counting specific values orusing subtotal function 2

Back
Top