AutoFilter Unavailable?

[Guest]

Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie

 

[JW]

Check that the worksheet is not protected.

 

[Gord Dibben]

Sheet protected?

More than one sheet selected? As in [group] mode in Title bar?


Gord Dibben MS Excel MVP

 

[Guest]

No, the worksheet is not protected. And there is not more than one sheet
selected.

Sheet protected?

More than one sheet selected? As in [group] mode in Title bar?


Gord Dibben MS Excel MVP

Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie

 

[Gord Dibben]

I can't think of anything else.

Hang in.........someone may come up with an answer.


Gord

No, the worksheet is not protected. And there is not more than one sheet
selected.

Sheet protected?

More than one sheet selected? As in [group] mode in Title bar?


Gord Dibben MS Excel MVP

Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie

 

[JP]

Do you have a workbook open? Autofilter won't work if you don't have
at least one workbook/worksheet open.


--JP

 

[Peo Sjoblom]

Are you serious?


--


Regards,


Peo Sjoblom

Do you have a workbook open? Autofilter won't work if you don't have
at least one workbook/worksheet open.


--JP

 

[JP]

Possible, right?

Also, check Tools Menu, Options

On the View tab, Objects section, select "Show All" or "Show
Placeholders"


HTH,
JP

 

[Gord Dibben]

I believe you got it with the Tools>Options>View


Gord

 

[JP]

Thank you, but without the OP to confirm, the world may never know.

--JP