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.
Thanks!
Hello, we are working on this request for Excel Online – https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters, more updates are coming later for Win32.
46 comments
-
Isaiah Berg commented
Please, please, please make co-authoring in the desktop application live up to its promise! Greatly appreciated!
-
CodeKnight commented
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.
-
Anonymous commented
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.
-
SWalter commented
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.
-
Steve commented
@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. -
Nico commented
Please add this filtering by person on cloud sheets for the desktop version.
-
Michael commented
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.
-
Anonymous commented
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?!?
-
Neil commented
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
-
CodeKnight commented
"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.
-
Anonym commented
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.
-
Anonymous commented
this is critically important. you said back in March you are working on it but it's still not available. can we have an update on when to expect this?
-
Anonymous commented
This is crazy it doesn't exist as part of co-authoring! A key part of collaboration...is filtering and sorting. Google have it and it's called 'Filter Views'
-
Anonymous commented
And make sure this works for Mac as well please