Unable to use filters

[mikeymay]

I have a worksheet that is unprotected but I am unable to apply filters to it. The option is greyed out if I try and select autofilters.

Another strange thing is that on one of the worksheets when I select Data, Filters there is a tick to the left of Autofilter but it is also greyed out, so in effect I cannot turn it off even tho I can't see the filters!!

I have tried to popst a screen shot but unsure how to do it. I think maybe a screen shot would help to explain my issue better so if anyone knows how to do this......

Thanks

 

[micromagnet]

Hit PRINT SCREEN button. Usually located above the INSERT key on your keyboard. Or if a laptop, then look for PRT SC. Usually comes after F12 key.

 

[mikeymay]

I can use this to paste the screen shot to Word, Paint, etc but it won't let me paste it into the thread.

Do I need to save to Paint file somewhere and specify it in the thread somehow?

 

[micromagnet]

Oops, sorry. Misunderstood. Maybe someone else can advise. I am not sure how to post onto the board.

 

[arthurbr]

Have a look at
http://www.mrexcel.com/board2/viewtopic.php?t=92622

 

[mikeymay]

Thanks for that arthurbr

Unfortunately, our IT department, in their ultimate wisdom, do not allow us to install add ins.......

Any other way of doing this, as a my last call to get an add in took 3 weeks to sort out

And I suppose we have gone off on a bit of a tangent here......does anyone know anything about my actual problem?!?!?

 

[Andrew Poulsom]

Is there any VBA code in the workbook?

 

[mikeymay]

No, there is no code in the worksheet.

 

[mikeymay]

This is the screen shot of my issue.

The autoFilter option is greyed out but is also active (see the tick). I cannot see any filters anywhere on my spreadhseet.

Any pointers would be helpful.

 

[mikeymay]

Does anyone have any ideas on this?

This spreadsheet is about 4000 rows in total and I really need the Filters function.

Some input would be greatly appreciated.


Thanks