AutoFilter Unavailable?
 

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

AutoFilter Unavailable?
 

Check that the worksheet is not protected.

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

AutoFilter Unavailable?
 

Sheet protected?

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


Gord Dibben MS Excel MVP

On Tue, 13 Nov 2007 12:15:00 -0800, Julieeeee
wrote:

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

AutoFilter Unavailable?
 

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

"Gord Dibben" wrote:

Sheet protected?

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


Gord Dibben MS Excel MVP

On Tue, 13 Nov 2007 12:15:00 -0800, Julieeeee
wrote:

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

AutoFilter Unavailable?
 

I can't think of anything else.

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


Gord

On Wed, 14 Nov 2007 06:09:03 -0800, Julieeeee
wrote:

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

"Gord Dibben" wrote:

Sheet protected?

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


Gord Dibben MS Excel MVP

On Tue, 13 Nov 2007 12:15:00 -0800, Julieeeee
wrote:

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

AutoFilter Unavailable?
 

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


--JP

On Nov 13, 3:15 pm, Julieeeee
wrote:
Why would auto filter be greyed out? I have never seen that happen before,
and I use autofilter all the time! Thanks - Julie

AutoFilter Unavailable?
 

Are you serious?


--


Regards,


Peo Sjoblom



"JP" wrote in message
oups.com...
Do you have a workbook open? Autofilter won't work if you don't have
at least one workbook/worksheet open.


--JP

On Nov 13, 3:15 pm, Julieeeee
wrote:
Why would auto filter be greyed out? I have never seen that happen
before,
and I use autofilter all the time! Thanks - Julie

AutoFilter Unavailable?
 

Possible, right?

Also, check Tools Menu, Options

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


HTH,
JP



On Nov 14, 1:26 pm, "Peo Sjoblom" wrote:
Are you serious?

--

Regards,

Peo Sjoblom

"JP" wrote in message

oups.com...



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

--JP

On Nov 13, 3:15 pm, Julieeeee
wrote:
Why would auto filter be greyed out? I have never seen that happen
before,
and I use autofilter all the time! Thanks - Julie- Hide quoted text -

- Show quoted text -

AutoFilter Unavailable?
 

I believe you got it with the ToolsOptionsView


Gord

On Wed, 14 Nov 2007 18:51:39 -0000, JP wrote:

Possible, right?

Also, check Tools Menu, Options

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


HTH,
JP



On Nov 14, 1:26 pm, "Peo Sjoblom" wrote:
Are you serious?

--

Regards,

Peo Sjoblom

"JP" wrote in message

oups.com...



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

--JP

On Nov 13, 3:15 pm, Julieeeee
wrote:
Why would auto filter be greyed out? I have never seen that happen
before,
and I use autofilter all the time! Thanks - Julie- Hide quoted text -

- Show quoted text -

AutoFilter Unavailable?
 

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

--JP

On Nov 14, 3:56 pm, Gord Dibben <gorddibbATshawDOTca wrote:
I believe you got it with the ToolsOptionsView

Gord



On Wed, 14 Nov 2007 18:51:39 -0000, JP wrote:
Possible, right?

Also, check Tools Menu, Options

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

HTH,
JP