Feedback by UserVoice

 

How can we improve Excel for the web? Vote for an existing idea or share a new one.

← Excel for the web

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?

2,654 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Joseph shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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!

Show previous admin responses (5)

657 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Pavlo Burchenko commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    I'm not seeing this either. Anyone else besides Jamie successful?

  • Jamie Scharf commented  ·   ·  Flag as inappropriate

    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.

  • a user has no filter commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Peter Collins commented  ·   ·  Flag as inappropriate

    @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.

  • Johannes Bø commented  ·   ·  Flag as inappropriate

    ProPlus is certainly pointing us in the right direction as this is a subscriopion for Office (desktop).

← Previous 1 3 4 5 … 32 33

Excel for the web: Collaboration and Sharing

Categories

Feedback and Knowledge Base

(thinking…)