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

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