Do you have multiple sheets grouped together?
Look for [Group] in the title bar.
If you do, then ungroup them.
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.
Gord said: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
Do you have multiple sheets grouped together?
Look for [Group] in the title bar.
If you do, then ungroup them.
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
Gord Dibben said: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
Do you have multiple sheets grouped together?
Look for [Group] in the title bar.
If you do, then ungroup them.
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
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 said: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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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 said: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.
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.
:
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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
Or maybe objects are hidden:
Tools>Options, View tab
Under Objects, choose Show All, or Show Placeholders
Dave said: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.
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.
:
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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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 said:Or maybe objects are hidden:
Tools>Options, View tab
Under Objects, choose Show All, or Show Placeholders
Dave said: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.
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.
:
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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
:
Or maybe objects are hidden:
Tools>Options, View tab
Under Objects, choose Show All, or Show Placeholders
Dave said: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.
:
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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
Gord said:Good choice Debra.
My money's on this solution.
Gord
Or maybe objects are hidden:
Tools>Options, View tab
Under Objects, choose Show All, or Show Placeholders
Dave said: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.
:
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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
Thanks -- looks like you placed a good bet.
Gord said:Good choice Debra.
My money's on this solution.
Gord
Or maybe objects are hidden:
Tools>Options, 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.
:
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
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.
:
I would suggest that your workSHEET is protected under Tools>Protection
Gord Dibben MS Excel MVP
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.