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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html