Allow for personal user views/filters
When using Excel Online, if you add a filter, everyone using that spreadsheet in Excel Online will see that filter. Can you please add an option for only the one user to see that filter?
Joseph
shared this idea
Thank you for your continued feedback and responses. We are glad to update that the work for this feature has started.
We’ll share more details as we progress.
Thanks!
654 comments
-
Harsh Damania
commented
How can a user enrol for beta features
-
Anonymous
commented
Filtern und Sortieren muss auch bei gemeinsamer Dokumenterstellung unten den enzelnen Users separat betrachtet werden. Ansonsten macht bei größeren Dokumenten diese Funktion absolut keinen Sinn. Wir haben in vergangenheit sehr viel mit Freigegebener Excel- Mappe sehr gern gearbeitet.
Viele Grüße
Ronny -
Harsh Damania
commented
Same experience for me, it works on my laptop, but it does not work for my colleague.
-
Tom G.
commented
My Sheet View not grayed out, and is usable, but have seen some colleagues laptops do not currently have the option.
-
Pavlo Burchenko
commented
It is clearly said on this page that the feature is in beta. https://support.office.com/en-us/article/learn-more-about-sheet-views-87fb6758-edbc-4cd0-bd68-76124775e9f8
Most probably, your Office or Sharepoint admin does not allow unreleased features in your organization. However, given that my personal home Excel Online doesn't have it either, means that the user might have to enroll themselves to some new feature testing programme first.
-
Anon
commented
I'm not seeing this either. Anyone else besides Jamie successful?
-
Jamie Scharf
commented
The option, which was greyed out before, has disappeared entirely for me. I do not have options from the other two suggestion ways to activate it in Tom G.'s link below, either.
-
Tom G.
commented
My Sheet View is now active on Outlook Online files, no longer Grayed Out.
Below is the how-to- use guide, from Microsoft -
LucNukem
commented
yes we need this please asap!! this is driving me nuts lol!!
-
a user has no filter
commented
we have faced the same issue in our work-group. individual settings to the autofilter is a must as much as it is a no-go by MS to not provide this functionality with 365 any longer.
one feasable workaround I have started my beta on is the following and it may even give you a new perspective on working with excel 365:
_creating individual pivot tables has proven a good and permanent alternative to resetting autofilter all the time. This is because once created, you this pivot can become a permanent and powerful filtering tool.
It can either be stored in the affected spread sheet itself or created as and external reporting/filtering tool.
Only downside may be, that the users may have to adapt their workflows and start working with excel pivot-tools. -
Anonymous
commented
We are 3 persons editing 1 workbook at the same time, almost the whole day. Unfortunately we need to use filters always. So, 1 person applies filter, starts to work, the second person applies his own filter and the first person is lost. Then, the third one comes and does the same. Especially for this reason I bought Office 365 for 2 persons to test it, because it did not work when I used Office 365 and my colleague used Office 2019. Now I sse that it does not work even when we are both having Office 365.
Strange company the Microsoft is:)...is doing the most to bring his customers to competition:D.
OK, let's try Google Docs now.
-
Martin
commented
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.
-
Damian Szigeti
commented
Need this asap please.
-
Peter Collins
commented
@Johannes No it's not, putting it in ProPlus puts a vital feature behind a further paywall. If they implement custom views for desktop, but put it behind a ProPlus subscription, it'll be a disgusting measure. The existence of Pro Plus is disgraceful enough, gating off functions behind a pro subscription that's dramatically more expensive than the regular Business Premium solution is disgusting.
-
Bruno Martins
commented
This is a must have!
-
Johannes Bø
commented
ProPlus is certainly pointing us in the right direction as this is a subscriopion for Office (desktop).
-
Peter Collins
commented
ProPlus is a disgrace
-
Anonymous
commented
26:25 in the video. Office 365 ProPlus required.
-
Pipo De Jesus
commented
We need to get this feature done online ASAP and must be implemented the soonest on the desktop version. For corporate users like us who are so compelled by our company to use SharePoint, this feature is a must!
-
Steve
commented
Great news, community
just out of ignite, it was announced to come out. so finally it has been finished and now we're just awaiting the rollout ;-)
if ya wanna see it your own, go watch the ignite video of Jeff Teper here: [#MSIgnite 11/4/19 #BRK2053]: https://myignite.techcommunity.microsoft.com/sessions/81522
"The latest innovations in SharePoint, OneDrive, and Office for content collaboration in Microsoft 36..."
