Allow custom filters in Excel (online and desktop) when co-authoring
When two or more users are co-authoring an Excel spreadsheet and one of the users applies a filter or edits the selections in a filter, every users view updates to display the filter settings. It would be better if each user could apply their own personal filter settings.
Rob Barker commented
@anonymous, it's only available in Excel Online (which is great) but we need it in Excel desktop.
This has been done. See https://techcommunity.microsoft.com/t5/excel-blog/sheet-view-is-generally-available/ba-p/1032576
No tiene sentido la colaboración de Excel sin esta función.
This function is ESSENTIAL. How did co-authoring come to be without this ????
yoann gouraud commented
we face the same issue
+& for this feature request
Jean-Luc De Lunardo commented
really a pain.... impossible to work properly...
Not having this working is enough for me to start playing with Google Sheets. It used not to be this way a few years back. Now it is a real Pain!!!
We need to have each user apply their own filters. Anyone new joining can live with whatever the last user turned on and adjust. This I can live with. Personal filters that stay on from session to session would be even better.
Ralph Wijbenga commented
Personal or private filter is very important for large files, while working together on a file. Without filters the large amount of data is not workable. But when the filters change while working..... Not happy!
This is a huge matter for users, even though it seems to a be a detail. That will prevent many of them to chose the Office365 ProPlus. One of the major reason why a medium-size company may chose Office 365 ProPlus is the co edition: however this very small problem kills the interest of it.
Please consider our request seriously, that will definitely generate more business for MS!
+1 for this feature request
the lack of this feature effectively kills the ability to collaborate in excel online
Yes it's important to launch this feature, collaborating is the main function of MS 365. If we cannot collaborate because someone use a filter it's unfortunate
Timo-Manuel Junge commented
We really do need this feature as well! Individual filters will enable co-authoring in situations where people edit the same file simultaneously, yet while having their specific dataset filtered.
In our company, we have a lot of people working in the same excel sheet and we need to be able to make custom filter/views so that each person can filter and see what they need to see without affecting all others working in the same sheet. Very important please work on a solution to help us... were getting more and more working on a same sheet... Thanks a lot!!
Felipe Rendon commented
I 1000% agree (yes I meant to type 1000).
Sieglinde is totally right, this is a must have for collaborating
I 100% agree.
It is horrible to work simultaneous at the moment.
Federico Rama commented
In Google Spreeadshet this is working correctly, is really annoying to colaborate at the same time and seeing only what others are filtering