Jun 19 2019 01:44 AM
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.
Jun 19 2019 06:40 AM - edited Jun 19 2019 06:43 AM
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
Jun 20 2019 03:55 AM
@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.
Jun 22 2019 10:44 AM
@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.
Jun 24 2019 01:32 AM
Solution@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.
Oct 21 2020 03:23 AM
@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..?
Oct 21 2020 03:47 AM
@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.
Oct 21 2020 05:40 AM
Oct 21 2020 05:44 AM
Jun 24 2019 01:32 AM
Solution@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.