Autofilter option not working while data in excel is Formatted as Table

%3CLINGO-SUB%20id%3D%22lingo-sub-901179%22%20slang%3D%22en-US%22%3EAutofilter%20option%20not%20working%20while%20data%20in%20excel%20is%20Formatted%20as%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901179%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BAutofilter%20option%20not%20working%20while%20data%20in%20excel%20is%20Formatted%20as%20Table.%20If%20data%20is%20not%20converted%20into%20table%2C%20then%20Autofilter%20option%20works%20perfectly.%20Please%20help%20in%20this%20case.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901244%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilter%20option%20not%20working%20while%20data%20in%20excel%20is%20Formatted%20as%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901244%22%20slang%3D%22en-US%22%3EHappy%20to%20help%20but%20please%20add%20some%20more%20information%20or%20even%20better%2C%20a%20screenshot%20where%20I%20can%20see%20the%20problem%3C%2FLINGO-BODY%3E
Occasional Contributor

 Autofilter option not working while data in excel is Formatted as Table. If data is not converted into table, then Autofilter option works perfectly. Please help in this case.

2 Replies
Happy to help but please add some more information or even better, a screenshot where I can see the problem

@PascalKTeam 

 

Hello, i am sending a picture this problem. I use alot of this solution.

 

I hope this picture good for you..

 

Miklós