Advanced Filtering is Unavailable

B

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
 
D

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'
 
B

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.
 
Top