I thought of that, but OP states the Advanced Filter is available which would
not be the case with grouped sheets.

If the workbook is shared Autofilter would be available and Advanced would be
grayed-out.

Everything is backwards<g


Gord

On Mon, 02 Apr 2007 15:36:25 -0500, Dave Peterson
wrote:

Do you have multiple sheets grouped together?

Look for [Group] in the title bar.

If you do, then ungroup them.

YanYan wrote:

Humm, i went to ToolsProtection and nothing is selected. I added protection
to sheet and workbook and then removed them just to make sure, same thing.

"Gord Dibben" wrote:

I would suggest that your workSHEET is protected under ToolsProtection


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 12:32:01 -0700, YanYan
wrote:

Why would the auto filter option be grayed out on my workbook? I dont have a
workbook protection on and can't figure out what other reasons would make it
gray out. Only my advance filter option is available.