SOLVED

O365 can not use filter function

%3CLINGO-SUB%20id%3D%22lingo-sub-2289571%22%20slang%3D%22en-US%22%3EO365%20can%20not%20use%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2289571%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22David_shu_0-1619406668258.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275435i4B552FBA2F178F21%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22David_shu_0-1619406668258.png%22%20alt%3D%22David_shu_0-1619406668258.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22David_shu_1-1619406692036.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275436i49B79127D6116613%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22David_shu_1-1619406692036.png%22%20alt%3D%22David_shu_1-1619406692036.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ewhy%20can%20not%20use%20the%20filter%20function%20in%20excel%20O365%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2289571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2289990%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20can%20not%20use%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2289990%22%20slang%3D%22en-US%22%3EIt%20appears%20your%20build%20number%20was%20released%20June%2011%2C%202019%20and%20the%20filter%20function%20was%20released%20in%20July%202020.%20I%20think%20your%20system%20administrator%20needs%20to%20push%20some%20updates.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fupdate-history-microsoft365-apps-by-date%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fupdate-history-microsoft365-apps-by-date%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

David_shu_0-1619406668258.pngDavid_shu_1-1619406692036.png

why can not use the filter function in excel O365?

2 Replies
best response confirmed by David_shu (New Contributor)
Solution
It appears your build number was released June 11, 2019 and the filter function was released in July 2020. I think your system administrator needs to push some updates.

https://docs.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date

https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759

Thank you so much, @JMB17