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
We are excited to announce that Sheet View is now available on Excel Web!
Thank you all for voting and influencing Excel Online priorities. Keep voting for other ideas you want us to address.
Thanks,
Excel Team [MSFT]
725 comments
-
Edward Paul commented
Well dear I can help you out to know how you can make your Excel file completely confidential. So that even if you share it with multiple users you don’t have to get worried about your data integrity.
Here is the video to make this task possible in an easy manner. -
Guest
commented
This feature needs to be improved. Please, all of you, vote for this idea:
https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/39398026-maintain-hidden-rows-columns-in-sheet-view-so-ot -
Anonymous
commented
que buena noticia!
-
Anonymous
commented
I would also need this feature in the desktop app too.
-
Anonymous
commented
Can you please add that user-specific filter feature for users editing files in the desktop app? I agree with Murray Mclean
-
Anonymous
commented
Und was mache ich, wenn wir die Frage falsch beantwortet haben und wir die Einstellung nachträglich ändern wollen? Im Deutschen ist die Frage schwer zu verstehen. Es ist nicht erkennbar welche Auswirkung die Antwort hat.
-
Anonymous
commented
Hi All.
Any possibility to have an option to filter by colour on the online version?
Thanks in advance. -
ThatMikeGuy
commented
@Abner, Did you just read the original request and not notice the update? Your post sounds like that. If there are issues with the new "Sheet View" that you have, well that would be helpful to hear. But the original post, and your critique, at this point is obsolete.
-
Abner
commented
it's been so many years since MS offered team collaboration on Office products. This shouldn't take this long to resolve. ONLY changes from any user should be synced so all users see, do NOT sync how 1 user views the document - be it filter, hidden column, etc. Come on MS! Google Docs offers such features years ago. Catch up.
-
Vinay Ambavle
commented
Sheet view is awesome!! loved it!! Now this is called real collaboration :)
-
Hari
commented
It is possible to apply multiple filter in Online Excel in one drive
-
Dan
commented
Google docs has a nifty Filter Views implementation. Waiting for microsoft's implementation in shared excel or teams.
-
Murray McLean
commented
Can you please add that user-specific filter feature for users editing files in the desktop app?
-
Stephen Royle
commented
The feature seems to work well and is really useful. My issue is I have to unprotect the worksheet in order to allow saved views to work. Temporary ones work though.
-
Aaron
commented
This functionality works great for tables, but pivot tables are still plagued by the same issue. Is there any way we could get this feature for pivot tables?
-
Dre
commented
Hi Microsoft,
What about the O365 local install version? This is where the problem still exists.Cheers
Andreas -
Phil Renda
commented
For those struggling with 'hide columns or rows' affecting everyone viewing, please vote here: https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/39398026-maintain-hidden-rows-columns-in-sheet-view-so-ot
-
Martin
commented
Sheet view doesn't work correctly for hiding columns (maybe rows as well). If I hide some columns, they are hidden in all views including default one.
-
Anonymous
commented
@anonymous 23 April - I thought I had imagined it! Thank you for validting that I hadn't. This was perfect and great functionality!
-
Anonymous
commented
What happened to the simple option from a while ago whereby when filtering it asked if it was for all users or just you?
That was really simple and very useful