Advanced Filtering is Unavailable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beau - 27 Oct 2006 21:46 GMT

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

Reply to this Message

Debra Dalgleish - 28 Oct 2006 03:43 GMT

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'

> 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

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Beau - 28 Oct 2006 04:44 GMT

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

> 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
[quoted text clipped - 3 lines]
> > Filtering is grayed out and not available. Is there a setting I need to
> > change to make this command available

Reply to this Message

Debra Dalgleish - 28 Oct 2006 04:47 GMT

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

> Thanks Debra - Yes, the workbook was shared. I "un-shared" it and I was able
> to use advanced filtering to fix my duplication problem.
[quoted text clipped - 6 lines]
>>>Filtering is grayed out and not available. Is there a setting I need to
>>>change to make this command available

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message