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.

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.

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.

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.



--

Dave Peterson

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.

Oops. I didn't read the whole message.

Gord Dibben wrote:

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.



--

Dave Peterson

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.

"Gord Dibben" wrote:

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.

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.

"Gord Dibben" wrote:

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.





--

Dave Peterson

Or maybe objects are hidden:

ToolsOptions, View tab
Under Objects, choose Show All, or Show Placeholders

Dave Peterson wrote:
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.

"Gord Dibben" wrote:


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.






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

Good choice Debra.

My money's on this solution.


Gord

On Mon, 02 Apr 2007 18:45:58 -0400, Debra Dalgleish
wrote:

Or maybe objects are hidden:

ToolsOptions, View tab
Under Objects, choose Show All, or Show Placeholders

Dave Peterson wrote:
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.

"Gord Dibben" wrote:


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.

THAAAAAANNNNKKKK YOU!!!! That worked.

"Debra Dalgleish" wrote:

Or maybe objects are hidden:

ToolsOptions, View tab
Under Objects, choose Show All, or Show Placeholders

Dave Peterson wrote:
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.

"Gord Dibben" wrote:


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.






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

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

YanYan wrote:
THAAAAAANNNNKKKK YOU!!!! That worked.

"Debra Dalgleish" wrote:


Or maybe objects are hidden:

ToolsOptions, View tab
Under Objects, choose Show All, or Show Placeholders

Dave Peterson wrote:

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.

"Gord Dibben" wrote:



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.



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





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

Thanks -- looks like you placed a good bet.

Gord Dibben wrote:
Good choice Debra.

My money's on this solution.


Gord

On Mon, 02 Apr 2007 18:45:58 -0400, Debra Dalgleish
wrote:


Or maybe objects are hidden:

ToolsOptions, View tab
Under Objects, choose Show All, or Show Placeholders

Dave Peterson wrote:

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.

"Gord Dibben" wrote:



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.





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

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



On Mon, 02 Apr 2007 22:17:27 -0400, Debra Dalgleish
wrote:

Thanks -- looks like you placed a good bet.

Gord Dibben wrote:
Good choice Debra.

My money's on this solution.


Gord

On Mon, 02 Apr 2007 18:45:58 -0400, Debra Dalgleish
wrote:


Or maybe objects are hidden:

ToolsOptions, View tab
Under Objects, choose Show All, or Show Placeholders

Dave Peterson wrote:

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.

"Gord Dibben" wrote:



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.