Forum Discussion

Copper Contributor

Jun 19, 2019

Solved

Excel Filter stumbling block - Teams / SharePoint / Excel Online

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 d...

migration

User Adoption

Mattwlkr
Jun 24, 2019
HustleGPTEnd 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.

Graham McHugh

Iron Contributor

Jun 19, 2019

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 https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters?tracking_code=b58146067ee2f09fd6605df37d0fe87b#%7Btoggle_previous_statuses%7D on the Excel feedback site.

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

https://support.office.com/en-gb/article/create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa

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

https://support.office.com/en-us/article/create-change-or-delete-a-view-of-a-list-or-library-27ae65b8-bc5b-4949-b29b-4ee87144a9c9

I hope some of that might help,

Graham

Mattwlkr
Copper Contributor
Jun 20, 2019
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.