Auto filters in shared spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1438542%22%20slang%3D%22en-US%22%3EAuto%20filters%20in%20shared%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438542%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20shared%20spreadsheet%20in%20Teams%20with%20autofilters%2C%20when%20staff%20are%20filtering%20they%20are%20sometimes%20given%20the%20choice%20to%20filter%20for%20themselves%2C%20or%20filter%20for%20everyone.%20Can%20I%20force%20them%20to%26nbsp%3B%20'filter%20for%20themselves'%2C%20as%20when%20they%20select%20for%20all%2C%20the%20filters%20disappear%20for%20all%20other%20users.%3C%2FP%3E%3CP%3EAm%20I%20missing%20som%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1438542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

I have a large shared spreadsheet in Teams with autofilters, when staff are filtering they are sometimes given the choice to filter for themselves, or filter for everyone. Can I force them to  'filter for themselves', as when they select for all, the filters disappear for all other users.

Am I missing som

1 Reply
Highlighted

@Calum Marshall 

I do not think there is an easy way for this. however you can try to use seperate workbooks for every worker and let them see their info only and then merge these workbooks in a main workbook with power query. You can place these personal workbooks to folders with access right assigned to that user and an administrator so that user can only open his own folder with his workbook and cannot access to other ones. 

The user who needs to merge all the data to the main workbook need to have access to all the users personel folder for power query to read them.