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
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!
713 comments
-
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
-
Sean Patterson commented
When will this be available for Excel 365?
-
Pavlo Burchenko
commented
@Jeff Craig
Hi Jeff! Could you please give more details? What is exactly the problem?
Thanks! -
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. :)
-
Anonymous
commented
When will this be available when using my desktop app and its a shared workbook
-
gracey
commented
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. =)
-
Futski
commented
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.
-
Support
commented
Hi Anonymous,
maybe you are not talking about Excel for the web, where this thread is posted -
Anonymous
commented
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
-
Anonymous
commented
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.
-
Anonymous
commented
Has this rollout been completed? I'm not seeing the new feature in the browser in a spreadsheet located in Teams.
-
Anonymous
commented
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?