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 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.
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
If you are following this thread, maybe you are trying to also create an Excel file with range protection (allowing users editing access to certain cells only). I found a bug in version 1902 about this feature and MS confirm it was corrected in a newer version. For unknown reasons, my Office wouldn’t update itself. An IT just fixed this for me by using this command :
"c:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeC2RClient.exe" /update user
That forced the update on my side. Now I am aligned with the most recent version : https://docs.microsoft.com/en-us/officeupdates/update-history-office365-proplus-by-date
I can see the new feature in Teams, my only gripe is that you require EDIT access in order to be able to create or select a view in Teams, if you don't a minimum of Edit you don't get the option in the task bar. This prevents it being used where you have protected your workbooks to stop teams/individuals making changes.
Has this rollout been completed? I'm not seeing the new feature in the browser in a spreadsheet located in Teams.
I just discovered this rolled out on my spreadsheet recently and im so so excited. This is a game changer for collaborative spreadsheets and will help win over those that are committed to google sheets.
John Unterseher commented
When will this roll out to GCC/H/DOD?