Filter option not working

[Leep]

I have been passed a spreadsheet with multiple columns with the headings
showing that filtering is available, but when I click ony of the column
headings it only shows Column Name: (Showing All). with no option to change
anything.

The ribbon bar sort and filter option is showing the Filter button as
highlighted orange, but looks to be greyed out with clear and reapply both
greyed.

Can anyone tell me what I need to do to get the filter working? Sorry if
this is a simple one, I have just never seen this before.

Cheers

Leep

 

[Dave Peterson]

If you remove the filter and then select the range (don't let excel guess!) and
then reapply the filter, does it work ok?

Is the worksheet protected?

Do you have more than one sheet selected (or grouped)?

 

[Leep]

Thanks Dave,

Yes it ooks like the spreadsheet is protected (and with a password I dont
know, Really helpfull).

Cheers
Lee

 

[Dave Peterson]

Time to go back to the author and ask him or her to protect the worksheet in
code--but allow autofilter to work.