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!
Bill Jelen
shared this idea
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.
24 comments
-
Anonymous
commented
I can see two potential work arounds for this, neither of them pretty:
1. You use a pivot table on the data which will give you view only view of the data
2. You break the bigger data set into individual user data sets and then recompile it back together with a Power Query. -
Mark P
commented
We have the same need - we have 6 people working on the sheet and over 4,000 rows and a tight deadline. with out separate filtering co-authoring doesn't help us.
-
Sabrina
commented
Please let us know when is the release date for filter function for excel online. Such a pain to update without filter for over 1000 rows!
-
Anonymous
commented
Hi microsoft team
Could you please let us know by when this functionality be released , for excel online
Thanks in advance ! -
Anonymous
commented
Yeah! Big challenge with having shared excel sheets where people can't view the document individually. Our work around is creating separate sheets using the "Get & Transform Data From Table/Range" feature of excel, which gives us read only filterable views for individual people (One Sheet per Person). Still have massive head aches in updating the data and helping people get to the data they want to update.
-
S. Agyei
commented
My team desperately needs this feature to maximize our productivity!
-
Kyle Dickinson
commented
This is a must have for co-authorizing. Individual filtering is causing confusions with users.
-
Carl Boyd
commented
There is a similar thread with 1123 votes already. Please use the larger thread to vote this up.
-
Anonymous
commented
Thanks for the update, Scott. This is one of the crucial missing features that has kept my team from transitioning from Googlesheets to Excel Online.
-
Anonymous
commented
When Microsoft !?
-
Anonymous
commented
Urgently need this. Please update us with how long this is going to take.
-
Steve
commented
there is a similar vote on this thread here, FYI:
Allow for personal user views/filters - https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters?tracking_code=ac6568636340730ee0ba8e78be9e290b -
Anonymous
commented
Any update regarding this? We have an entire team who work on the same workbook at the same time, and now, when one person filters a column, all the other users lose their place and start typing in the wrong cell! This needs to be addressed URGENTLY. It literally means they can't do their jobs!
-
Natasha Gossman
commented
FYI, the other link with the same topic has just been set as "planned" by Microsoft. They posted a link to a survey for people to request the most important features of the new upgrade. I highly suggest going to the link below so we can consolidate this issue and get this done! Almost there!
-
Darcy T
commented
Yes, same issue.
-
Anonymous
commented
Hey guys.
Is this the same topic?
https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters -
Shaun
commented
Need this!!!
-
Robert Barker
commented
This is a must-have to make the co-authoring experience with a large data set work efficiently.
-
Anonymous
commented
This is very problematic and defeats the value of co-authoring for us! Can't wait to see the change for this.
-
Nathan
commented
@Excel Team [MSFT] -- PLEASE hurry with an update for this. We rolled out co-authoring to our business and accounting departments who rely heavily on filters and needed co-authoring. Now, we went through this whole upgrade only to find out it doesn't work. Wouldn't co-authoring monitor the actual cell location of the user editing, why would filters effect that?
Yet, amazingly, I am unsurprised this is a thing. Microsoft is notorious for giving you much needed features, with ridiculous caveats.