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?

Hi Joseph,
We are now shipping a feature called Sheet View on Excel for the web that can help you sort and filter while collaborating with others. You can accomplish your tasks in a Sheet View without others impacting your workflow. Learn more here: https://techcommunity.microsoft.com/t5/Excel-Blog/Sheet-View-is-generally-available/ba-p/1032576
We’ve started the rollout to users on Excel for the web and will be available to all Excel for the web users within the coming weeks.
Thanks!
657 comments
-
Nadia commented
The Share View Option is not available for my but it is for my colleague? Why?
-
Futski commented
@Harsh Damania - You can apply for the Office Insider program at https://insider.office.com. That should get you the newest features before anyone general availability.
-
Anonymous commented
what is the latest situation over here?
-
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