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