Filtering Needs to Work in Co-Authoring
Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
It is more important to us to be able to have each person apply a local filter than to have the rare AGGREGATE function work correctly.
Hi folks, great news!
Sheet View is now available in the production ring of our monthly channel.
You can see it in the following builds and newer:
Peter Collins commented
There's no point to having this filter / sort functionality if you can't edit what your filtering on without imparing what others are doing. Alternatively, if there was any way for something like Powerquery to feed back into the table being queried, that would be nice.
Isaiah Berg commented
Please, please, please make co-authoring in the desktop application live up to its promise! Greatly appreciated!
This feature is a must. Just think of a daily report used by multiple department heads. They will want to filter their own values and they all will open the file at eight o'clock in the morning.
Airtable has solved this in a good way. Multiple editable views created by users, all connected to database backend. Unfortunately MS Excel doesn't really work like this. As the data you see is the data you are editing. Maybe MS Excel could solve this through the creation of connected tables, that update in real time between each other, that way you can filter one table without affecting the other.
As many others have stated, this ability is needed for the desktop version. The ability for only the online version is not worth mentioning to users.
This is needed more for the desktop version in our Org than in Excel online, we work almost exclusively in the desktop because of the lack of features in the online version, most notably the ability to run macros. I really can't believe they built it just for the online version and not the desktop, creating an even bigger divide between the abilities of each version.
But yet, the desktop and online versions are supposed to function together?? No way to justify this to our users, I am not even telling them about the this being added to the online version.
Pipo De Jesus commented
Why is this taking too long to implement? For corporate users like us, this feature is a must.
@Nico: for the online version, we just got the announcement from ignite that it will be coming. watch Jeff Teper's session video here: https://myignite.techcommunity.microsoft.com/sessions/81522
it comes soemwhere in the middle as "sheet view" under the "Intelligence and collaboration enhancements to Office" topic.
Please add this filtering by person on cloud sheets for the desktop version.
No good just to have it for the online version as the size of the documents for excel online is very small..
Please add this feature to desktop as well.
We have disabled Autosave with Office 365 ProPlus at our organization due to this issue. One of the major selling points of real time co-authoring cannot be used in the current state. You cannot have everyone's view change immediately when one person sorts or filters.
Carlos Botero commented
At our company, we are also interested in this feature to work on both, the Web and the Desktop app.
James Young commented
This is causing pain for many if our users and still no end in site. Please provide some feedback MS?!?
Hoping this development can be achieved. Vote from me
Robert Barker commented
It's great to heat the announcement at Ignite that this is being delivered for Excel Online by the end of the year, but PLEASE we DESPERATELY need this in the desktop version.
Christina M Costello commented
This is a must! As Microsoft promotes collaboration, it's frankly crazy that this is not available!
Peter Collins commented
Not just filter, we need to be able to edit the data by what we've filtered
Its been 3-4 years..has there been any progress on this feature?
"Airtable" does this well. As many views as you want, in different formats and layouts, can enter data on any view and it enters directly into the main data set and is visible by all users, on all other views.
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.