Filters not working on shared excel document

%3CLINGO-SUB%20id%3D%22lingo-sub-2159254%22%20slang%3D%22en-US%22%3EFilters%20not%20working%20on%20shared%20excel%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2159254%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20excel%20documents%20shared%20with%20roughly%20100%20employees%20of%20mine%20within%20OneDrive.%20Both%20use%20similar%20functionality%20with%20basic%20filters%20for%20all%20active%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20multiple%20users%20are%20in%20the%20document%20and%20they%20filter%20to%20the%20pertinent%20information%20for%20them%2C%20they%20select%20a%20filter%20which%20prompts%20the%20document%20to%20ask%20if%20they%20want%20to%20%22See%20Just%20Mine%22%20or%20%22See%20Everyone's%22.%20They%20always%20select%20%22See%20Just%20Mine%22%20due%20to%20multiple%20users%20being%20in%20the%20document%20at%20the%20same%20time%20but%20wanting%20to%20see%20only%20their%20information.%20Was%20working%20normally%20for%20months.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENOW...whenever%20someone%20goes%20to%20filter%20and%20click%20%22See%20Just%20Mine%22%2C%20nothing%20happens.%20The%20filters%20do%20not%20change%20at%20all%20in%20any%20scenario.%20I%20thought%20the%20filters%20were%20broken%20so%20I%20tested%20and%20it%20DOES%20work%20if%20they%20click%20%22See%20Everyone's%22.%20However%2C%20this%20can%20not%20be%20used%20do%20to%20multiple%20users%20needing%20to%20filter%20at%20the%20same%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20issue%20arose%20suddenly%20with%20both%20of%20my%20seperate%20shared%20documents%20at%20the%20same%20time.%20I%20attempted%20to%20save%20a%20local%20copy%2C%20repost%2C%20and%20reshare.%20This%20did%20not%20work.%20I%20also%20tried%20taking%20out%20the%20filters%20and%20re-inputting%20them.%20Also%20didn't%20work.%20Tried%20reaching%20out%20to%20any%20online%20or%20over%20the%20phone%20tech%20support%2C%20which%20also%20didn't%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPLEASE%20HELP!!!!!!%20THANKS!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2159254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have two excel documents shared with roughly 100 employees of mine within OneDrive. Both use similar functionality with basic filters for all active columns. 

 

When multiple users are in the document and they filter to the pertinent information for them, they select a filter which prompts the document to ask if they want to "See Just Mine" or "See Everyone's". They always select "See Just Mine" due to multiple users being in the document at the same time but wanting to see only their information. Was working normally for months. 

 

NOW...whenever someone goes to filter and click "See Just Mine", nothing happens. The filters do not change at all in any scenario. I thought the filters were broken so I tested and it DOES work if they click "See Everyone's". However, this can not be used do to multiple users needing to filter at the same time. 

 

This issue arose suddenly with both of my seperate shared documents at the same time. I attempted to save a local copy, repost, and reshare. This did not work. I also tried taking out the filters and re-inputting them. Also didn't work. Tried reaching out to any online or over the phone tech support, which also didn't work. 

 

PLEASE HELP!!!!!! THANKS!

0 Replies