I have a workbook where the autofilter does not seem to work. Usualy it is a
merged cell, but I have tried one column and mult sheets. I can copy this to
another workbook and it will work.

Any clue why autofilter would not work? (it is greyed out)

Ok, got it figured out. I did not have the sheet protected or choosing mult
sheets. It turned out that the workbook had in the Tools/Options View Tab
the "Hide All" in the objects. Once I did Show All, then my data/Autofilter
became un-gray

thanks

"Don" wrote:

I have a workbook where the autofilter does not seem to work. Usualy it is a
merged cell, but I have tried one column and mult sheets. I can copy this to
another workbook and it will work.

Any clue why autofilter would not work? (it is greyed out)