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!
705 comments
-
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?
-
JOSE LOPEZ DAVIDSON
commented
Agree. This is really usefull.
Waiting for roll-out to be using it. -
Laurence Bridger
commented
Bug Report: We have a document used for tracking projects and in some of it the cells are protected. We have many users updating their own records on there and have realised that using Filters affects everyone while in Excel. Using the browser view the Sheet View feature seems to work, but when I save a view and try to open it later I get the message "This sheet is protected. Some parts may be view-only and can't be changed" - please look in to this urgently. Thanks
-
Peter Collins
commented
Needs to work with hidden columns
-
Toshimichi Sasage
commented
I need this feature on desktop application as well.
-
Michael Falck
commented
Nice feature!
Do you know when this personal view is supporting hidden or grouped columns? - it is VERY disturbing when the grouped columns "expand/collapse function" are used, with multiple users in the same sheet.Thanks!
-
Anonymous
commented
unfortunately this feature doesn't work with files stored on box, only on onedrive. would it be possible to enable this feature for box as well, as lots of businesses use this? thanks!
-
Christina
commented
When will this fix be available in the desktop app? Working in the web app is painful.
-
Steve Berardi
commented
Working great! Finally! Any chance we can get Hidden Columns to work with this as well?