Autofilter

[agility]

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

 

[Gord Dibben]

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

 

[agility]

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

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

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

 

[Gord Dibben]

Thanks for the update.

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


Gord

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

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

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

 

[Max]

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...

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP