Excel is missing personalized Filter Views for live collaboration
Excel Online does not have a personalized Filter View? Can Microsoft implement the ability for each user to have their own filter view during "Share" or collaboration mode. currently, all users see live Filter views which is cumbersome when collaboration in Excel Online. Google Doc's already have a feature called "Filter Views" where each user can create their own Filter that is private during collaboration. In addition, Google filter view allows you to save multiple filter views for future use, which is perfect. WHEN will this feature be implemented? Road map dates for this feature should be published by the Developement team, otherwise, we will move our entire Business fleet over to G-Suite Google Sheets. Please provide details timeline for this feature. Again, Google has had this feature available for more than a Year, so Microsoft really needs to catch up.
Screen shot below shows Google's Filter View:
Yes I agree. I receive support tickets regarding this regularly. The issue being that with multiple users collaborating on an Excel spreadsheet, everybody's view of the spreadsheet is immediately changed when one user applies a Filter to a column. Very unsettling, confusing and unworkable for users.