Re: Auto Filter Option grayed out

Gord Dibben

unread,

Apr 2, 2007, 3:59:57 PM4/2/07

to

I would suggest that your workSHEET is protected under Tools>Protection

Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 12:32:01 -0700, YanYan <Yan...@discussions.microsoft.com>
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.

Dave Peterson

unread,

Apr 2, 2007, 4:36:25 PM4/2/07

to

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 Tools>Protection and nothing is selected. I added protection
> to sheet and workbook and then removed them just to make sure, same thing.

--

Dave Peterson

Gord Dibben

unread,

Apr 2, 2007, 5:31:38 PM4/2/07

to

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 <pete...@verizonXSPAM.net>
wrote:

Dave Peterson

unread,

Apr 2, 2007, 5:40:32 PM4/2/07

to

Oops. I didn't read the whole message.

--

Dave Peterson

unread,

Apr 2, 2007, 5:56:17 PM4/2/07

to

Could it be a developer who screwed up?

Maybe they wanted to disable the autofilter and never re-enabled it.

You could try:
Tools|Customize|toolbars tab|Select worksheet menu bar
and click Reset

You will lose any other customized changes you've made to that toolbar, though.

YanYan wrote:
>
> Thank you all for the suggestions, still havent figured out what is making
> the auto filter gray out, it is not procected and it is not grouped.
> Please let me know if you think of anything else.

--

Dave Peterson

Debra Dalgleish

unread,

Apr 2, 2007, 6:45:58 PM4/2/07

to

Or maybe objects are hidden:

Tools>Options, View tab
Under Objects, choose Show All, or Show Placeholders

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

Gord Dibben

unread,

Apr 2, 2007, 6:59:29 PM4/2/07

to

Good choice Debra.

My money's on this solution.

Gord

On Mon, 02 Apr 2007 18:45:58 -0400, Debra Dalgleish <d...@contexturesXSPAM.com>
wrote:

YanYan

unread,

Apr 2, 2007, 8:10:02 PM4/2/07

to

THAAAAAANNNNKKKK YOU!!!! That worked.

Debra Dalgleish

unread,

Apr 2, 2007, 10:16:40 PM4/2/07

to

You're welcome! Thanks for letting me know that it worked.

Debra Dalgleish

unread,

Apr 2, 2007, 10:17:27 PM4/2/07

to

Thanks -- looks like you placed a good bet.

Gord Dibben

unread,

Apr 2, 2007, 11:13:52 PM4/2/07

to

Now, if I just had some real money to wager<g>

On Mon, 02 Apr 2007 22:17:27 -0400, Debra Dalgleish <d...@contexturesXSPAM.com>