SOLVED
Home

Excel Filter stumbling block - Teams / SharePoint / Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-705958%22%20slang%3D%22en-US%22%3EExcel%20Filter%20stumbling%20block%20-%20Teams%20%2F%20SharePoint%20%2F%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-705958%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20trying%20to%20rollout%20SharePoint%20and%20Teams%20but%20have%20hit%20a%20real%20stumbling%20block%20with%20Excel%20filters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20lot%20of%20our%20people%20work%20on%20shared%20spreadsheets%20and%20apply%20multiple%20filters.%20When%20we%20come%20to%20demoing%20this%20with%20Teams%20or%20SharePoint%20the%20issue%20is%20raised%20with%20not%20being%20able%20to%20work%20shared%20with%20different%20filters%20for%20different%20people.%20There%20is%20no%20easy%20workaround%20for%20users%20that%20I%20have%20yet%20come%20across.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20you%20doing%20to%20get%20around%20this%3F%20Seems%20like%20a%20real%20oversight%20not%20to%20allow%20multiple%20users%20apply%20filters%20to%20there%20own%20view%20without%20effecting%20others.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrent%20they%20are%20using%20shared%20spreadsheets%20on%20a%20file%20server.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-705958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-707133%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Filter%20stumbling%20block%20-%20Teams%20%2F%20SharePoint%20%2F%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355021%22%20target%3D%22_blank%22%3E%40Mattwlkr%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20ability%20to%20do%20what%20you%20are%20asking%20is%20in%20demand%20and%20has%20been%20in%20the%20works%20for%20some%20time%3B%20you%20can%20upvote%20the%20idea%20%3CA%20title%3D%22Allow%20for%20personal%20user%20views%2Ffilters%20in%20shared%20Excel%20file%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-online%2Fsuggestions%2F8192445-allow-for-personal-user-views-filters%3Ftracking_code%3Db58146067ee2f09fd6605df37d0fe87b%23%257Btoggle_previous_statuses%257D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%20on%20the%20Excel%20feedback%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Excel%20data%20is%20static%2C%20it%20might%20be%20worth%20considering%20transferring%20it%20to%20a%20SharePoint%20list%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CA%20title%3D%22Create%20a%20list%20based%20on%20a%20spreadsheet%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fcreate-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%20a%20list%20based%20on%20a%20spreadsheet%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsers%20would%20then%20be%20able%20to%20create%20their%20own%20personal%20views%20of%20the%20SharePoint%20list%20(filters%2C%20etc.)%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CA%20title%3D%22Create%2C%20change%2C%20or%20delete%20a%20view%20of%20a%20list%20or%20library%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-change-or-delete-a-view-of-a-list-or-library-27ae65b8-bc5b-4949-b29b-4ee87144a9c9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%2C%20change%2C%20or%20delete%20a%20view%20of%20a%20list%20or%20library%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20some%20of%20that%20might%20help%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGraham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-710128%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Filter%20stumbling%20block%20-%20Teams%20%2F%20SharePoint%20%2F%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710128%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4765%22%20target%3D%22_blank%22%3E%40Graham%20McHugh%3C%2FA%3EYeah%20this%20spreadsheet%20is%20generated%20each%20day%20and%20worked%20on%20by%20multiple%20people.%20Creating%20a%20new%20list%20everyday%20isn't%20viable.%20This%20applies%20for%20multiple%20users%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4%20years%20and%20still%20nothing%20from%20MS.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715400%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Filter%20stumbling%20block%20-%20Teams%20%2F%20SharePoint%20%2F%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355021%22%20target%3D%22_blank%22%3E%40Mattwlkr%3C%2FA%3EHave%20standard%20filter%20templates%20for%20particular%20tasks.%26nbsp%3B%20That%20is%20far%20easier%20then%20the%20insanity%20under%20the%20hood%20you%20are%20actually%20asking%20for.%26nbsp%3B%20You%20cannot%20have%20a%20collaborative%20platform%20that%20concentrates%20on%20independent%20design.%26nbsp%3B%20Excel%20is%20very%20customizable%20and%20that%20is%20necessary%2C%20but%20only%20if%20standards%20are%20applied%20can%20it%20not%20be%20a%20chaotic%20addition%20when%20you%20scale.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716203%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Filter%20stumbling%20block%20-%20Teams%20%2F%20SharePoint%20%2F%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77001%22%20target%3D%22_blank%22%3E%40Justin%20Strachan%3C%2FA%3EEnd%20users%20don't%20care%20for%20the%20complexities%20under%20the%20hood%2C%20If%20google%20can%20sort%20this%20out%20surely%20MS%20can.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EImagine%20being%20sat%20in%20a%20car%20and%20only%20one%20person%20at%20a%20time%20can%20use%20a%20window%2C%20I%20wouldn't%20buy%20this%2C%20and%20users%20aren't%20going%20to%20buy%20into%20excel%20online%20if%20they%20can't%20individually%20filter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Mattwlkr
New Contributor

We are trying to rollout SharePoint and Teams but have hit a real stumbling block with Excel filters.

 

A lot of our people work on shared spreadsheets and apply multiple filters. When we come to demoing this with Teams or SharePoint the issue is raised with not being able to work shared with different filters for different people. There is no easy workaround for users that I have yet come across.

 

What are you doing to get around this? Seems like a real oversight not to allow multiple users apply filters to there own view without effecting others.

 

Current they are using shared spreadsheets on a file server.

4 Replies
Highlighted

@Mattwlkr ,

 

The ability to do what you are asking is in demand and has been in the works for some time; you can upvote the idea here on the Excel feedback site.

 

If the Excel data is static, it might be worth considering transferring it to a SharePoint list:

 

Users would then be able to create their own personal views of the SharePoint list (filters, etc.):

 

I hope some of that might help,

 

Graham

Highlighted

@Graham McHughYeah this spreadsheet is generated each day and worked on by multiple people. Creating a new list everyday isn't viable. This applies for multiple users here.

 

4 years and still nothing from MS.

Highlighted

@MattwlkrHave standard filter templates for particular tasks.  That is far easier then the insanity under the hood you are actually asking for.  You cannot have a collaborative platform that concentrates on independent design.  Excel is very customizable and that is necessary, but only if standards are applied can it not be a chaotic addition when you scale.

Highlighted
Solution

@Justin StrachanEnd users don't care for the complexities under the hood, If google can sort this out surely MS can.

 

Imagine being sat in a car and only one person at a time can use a window, I wouldn't buy this, and users aren't going to buy into excel online if they can't individually filter.

Related Conversations
Remove duplicates not working properly
Mcelli in Excel on
1 Replies
Populate summary page in Excel
Carissa_aggie in Excel on
0 Replies
Formatting Cells with Multiple Conditions
nozygatos in Excel on
1 Replies
Bonus calculation % achieved, % payout
Jennifer Lefief in Excel on
3 Replies
Pulling word data into excel
amandamy in Excel on
0 Replies
True of false if any column is non-blank
Ocasio27 in Excel on
1 Replies