Excel Online Not Filtering Correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-1388795%22%20slang%3D%22en-US%22%3EExcel%20Online%20Not%20Filtering%20Correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388795%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20filter%20on%20Excel%20online%20but%20it%20keeps%20bringing%20in%20rows%20that%20are%20not%20part%20of%20the%20filter.%20Didn't%20have%20this%20issue%20previously%2C%20just%20started%20happening%20a%20couple%20of%20days%20ago.%20Problem%20is%20still%20the%20same%20if%20opened%20on%20different%20browser.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1388795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393919%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20Not%20Filtering%20Correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393919%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667589%22%20target%3D%22_blank%22%3E%40Perfect_Mortgages%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecould%20it%20possible%20to%20share%20the%20file%20link%20keeping%20it%20in%20the%20OneDrive.%20have%20you%20tried%20making%20a%20new%20copy%20of%20the%20file%20and%20dose%20the%20issue%20remains%20%3F%20is%20it%20only%20for%20a%20specific%20file%20or%20all%20the%20Excel%20Files%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, I am trying to filter on Excel online but it keeps bringing in rows that are not part of the filter. Didn't have this issue previously, just started happening a couple of days ago. Problem is still the same if opened on different browser.

1 Reply
Highlighted

Hi @Perfect_Mortgages 

 

could it possible to share the file link keeping it in the OneDrive. have you tried making a new copy of the file and dose the issue remains ? is it only for a specific file or all the Excel Files ?

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more