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.
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
Stephen Callias commented
Même problème : Même demande...
Tyler Boggs commented
I agree this is a great suggestion! One of my biggest gripes is a monthly Excel file I work on with 5 others and if someone filters the sheet, I cannot edit the cells I am after. Personal filters would be really efficient for co-authoring! Please make this for the Mac version as well!
I agree that this is great suggestion!
Microsoft has apparently started work on this as noted on the duplicate User Voice here: https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/8192445-allow-for-personal-user-views-filters
Hopefully we see this implemented soon :)
In our workplace 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.
Guillaume BRION commented
Hello, this issue is one of the biggest issue making us regretting from switching from "Shared" Excel files through the network to "Coedition" Excel Files. Please let us know when it will be fixed.
Lionel Manta commented
Hello, May I have a feedback on this issue ? Or any workaround ?