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?
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.
Excel Team [MSFT]
@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.
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 :)
It is possible to apply multiple filter in Online Excel in one drive
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.
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?
What about the O365 local install version? This is where the problem still exists.
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
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 23 April - I thought I had imagined it! Thank you for validting that I hadn't. This was perfect and great functionality!
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
Sean Patterson commented
When will this be available for Excel 365?
Pavlo Burchenko commented
Hi Jeff! Could you please give more details? What is exactly the problem?
Jeff Craig commented
Can we disable the excel online button to filter for the group. I have a lot of folks using this, and one person clicking the wrong button still breaks everyone's flow. :)
When will this be available when using my desktop app and its a shared workbook
i can see this feature now and we've tested it. this is fantastic! thank you so much for finally activating this feature !!! collaborating will be much easier from now on. =)
Great news for everyone who wants this feature in the Desktop app. Believe it or not, MS posted an update here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31976935-filtering-needs-to-work-in-co-authoring to get this feature working in the desktop app. And the update was dated today, Mar 13, 2020. I'm truly floored. I didn't think I'd ever see the day when MS posted an update. I just pray it's completed sometime before the end of time.
maybe you are not talking about Excel for the web, where this thread is posted