SOLVED

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%20noopener%20noreferrer%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%20noopener%20noreferrer%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%20noopener%20noreferrer%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%3CLINGO-SUB%20id%3D%22lingo-sub-1802958%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-1802958%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%3Ehi%20there%2C%20when%20I%20filter%20Excel%20using%20the%20shared%20version%20on%20Teams%20or%20Sharepoint%2C%20the%20filter%20takes%20the%20curor%20to%20the%20bottom%20of%20the%20spreadsheet%20that%20takes%20a%20few%20minutes%20to%20scroll%20up%20to%20the%20results.%20Surely%20that%20shouldnt%20be%20the%20case%3F%3C%2FP%3E%3CP%3EAlso%20I%20cant%20filter%20by%20cell%20colour.%20I%20can%20'sort'%20by%20cell%20colour%20but%20that%20isnt%20the%20same%20thing.%3C%2FP%3E%3CP%3EAlso%20the%20sheet%20doesnt%20auto%20populate%20when%20putting%20the%20same%20data%20as%20the%20cell%20above.%3C%2FP%3E%3CP%3EAny%20help%20please..%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803005%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-1803005%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F840464%22%20target%3D%22_blank%22%3E%40akcity%3C%2FA%3E%26nbsp%3B%20Probably%20depends%20on%20the%20size%20of%20the%20sheet%2C%20CTRL%2BHome%20should%20see%20you%20to%20the%20top.%3C%2FP%3E%3CP%3Ethe%20online%20version%20is%20missing%20a%20few%20features%2C%20you%20may%20need%20to%20use%20the%20desktop%20version%2C%20which%20of%20course%20would%20effect%20the%20view.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803365%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-1803365%22%20slang%3D%22en-US%22%3EThanks%20that%20works%20%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%20I%20suppose%20one%20of%20the%20features%20missing%20seems%20to%20be%20auto%20population%20of%20cells%20of%20identical%20data...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803369%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-1803369%22%20slang%3D%22en-US%22%3EA%20few%20spreadsheets%20I%20have%20online%20are%20formatted%20as%20a%20table%20and%20will%20auto%20fill.%20Perhaps%20that%20works%20for%20you%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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.

8 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
Best Response confirmed by Deleted
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.

Highlighted

@Mattwlkrhi there, when I filter Excel using the shared version on Teams or Sharepoint, the filter takes the curor to the bottom of the spreadsheet that takes a few minutes to scroll up to the results. Surely that shouldnt be the case?

Also I cant filter by cell colour. I can 'sort' by cell colour but that isnt the same thing.

Also the sheet doesnt auto populate when putting the same data as the cell above.

Any help please..?

Highlighted

@akcity  Probably depends on the size of the sheet, CTRL+Home should see you to the top.

the online version is missing a few features, you may need to use the desktop version, which of course would effect the view.

Highlighted
Thanks that works @Mattwlkr I suppose one of the features missing seems to be auto population of cells of identical data...
Highlighted
A few spreadsheets I have online are formatted as a table and will auto fill. Perhaps that works for you?