Enable multiple users to sort/filter the same data table in different ways simultaneously
Our company would greatly benefit from the ability for multiple people to log in to the same Excel Online document and sort/filter the same table in different ways on each of their devices without affecting the sort/filter of the other users, and yet be able to update the underlying information in each view of the table in a way that appears immediately in each table.
this is discussed also under the topic "Allow for personal user views/filters"
as of 8/02/19 work has commenced, looking forward to a solution
There is a comment from admin on another post on this, and there is a survey you can fill in - link below
Excel Team [MSFT] (Admin, Office.com) responded · Sep 14, 2018
Thank you for your continuous feedback over the last few months. I’m glad to update you that this work has now been planned.
To help us design the feature to properly serve your sort/filter needs in your collaboration workflows in Excel, please help to fill in this short questionnaire – https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR4rWDU67-bdHnMt3Vmrztn9UNjJZUFg5UkxSSVFEQVJHQ1JDT1RCMkJLSy4u