The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.

Do you see [Group] in the Title Bar?

This means you have more than one sheet selected.

Autofilter will not work in this case.

Grouped sheets will have a white tab.

NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.

While in group mode, what you do to one sheet will be done to all.

Select a non-white sheet to ungroup.


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 07:49:03 -0800, agility
wrote:

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.

Excellent - fixed. Never knew about "grouped" tabs. Thanks so much!

"Gord Dibben" wrote:

Do you see [Group] in the Title Bar?

This means you have more than one sheet selected.

Autofilter will not work in this case.

Grouped sheets will have a white tab.

NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.

While in group mode, what you do to one sheet will be done to all.

Select a non-white sheet to ungroup.


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 07:49:03 -0800, agility
wrote:

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.

Thanks for the update.

Hope you didn't do too much mucking about while the sheets were grouped.


Gord

On Fri, 22 Feb 2008 09:00:01 -0800, agility
wrote:

Excellent - fixed. Never knew about "grouped" tabs. Thanks so much!

"Gord Dibben" wrote:

Do you see [Group] in the Title Bar?

This means you have more than one sheet selected.

Autofilter will not work in this case.

Grouped sheets will have a white tab.

NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.

While in group mode, what you do to one sheet will be done to all.

Select a non-white sheet to ungroup.


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 07:49:03 -0800, agility
wrote:

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected, not grouped, and no frozen
pane...

"agility" wrote:

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.

When you state "not grouped" do you mean you don't have multiple sheets
selected?


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 09:12:02 -0700, Max wrote:

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected, not grouped, and no frozen
pane...

"agility" wrote:

The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.