Advanced Filtering is Unavailable

[Beau]

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

 

[Debra Dalgleish]

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'

 

[Beau]

Thanks Debra - Yes, the workbook was shared. I "un-shared" it and I was able
to use advanced filtering to fix my duplication problem.

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know how you fixed the problem.