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!
687 comments
-
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 Hale
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?
-
Anonymous
commented
I have this feature. yay!!!!!!!!!! Thank you
-
Peter Collins
commented
Daniel, It's not a real support account
-
Support
commented
Only Android App, Regards Daniel
-
Daniel Wübbold
commented
Hello,
The rollout will be completed in Q2 2013.
That means the rollout of the Web version, or of the offline App? -
Danté
commented
I have been lucky enough to get it already, and it works well, they have it to where you can save the changes that you made as an option to click, so it filters like that with just a couple clicks.
-
Support
commented
The roll out will be completed in 2023 Q2. Regards
-
Andy
commented
When will the roll out be completed? I've tried to ask Support but they don't have a clue!
-
Attila
commented
The only thing what I don't understand: the old shared workbook has the same personal views/filters feature which is so wanted in the new version. You can check it in View tab / Workbook Views group / Custom Views - after you share your workbook with the secret Share Workbook (Legacy) command. So this functionality was working (and currently is working) in the desktop version - why so difficult to continue this feature in the new version?
-
Futski
commented
I'm not making excuses for MS, but my guess is that they are using the web version as a trial balloon to see if people really wanted personal views/filters. From the response here, it looks like it is a very desired feature.
@Matt, as a programmer, I feel confident in saying that the desktop version does have it's own set of complications when compared to the Web version. Excel Desktop dates back to 1985. Knowing how programs get updated through the years, the code probably got bastardized thru the years without ever getting a thorough rewrite. It's probably multiple millions of lines long with some of the code dating back to 1985. As a result it could be much more difficult to add personal views/filters to Desktop than to the relatively young Web version. I can assure you that old code is almost always much more difficult to modify than modern new code.
But Desktop is where this really, really, really needs to be...
Come on MS, When??? Can you give us an estimate?
-
Anonymous
commented
Same for me. Our users are happy with this new feature but are really expecting it to be implemented in the Desktop version.
Are you working on it?... And if so, any idea of the release date? ;) -
Matt Peterson
commented
The feature request link for the desktop version of Excel 365 is here: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31976935-filtering-needs-to-work-in-co-authoring
I agree, it's too bad they couldn't implement this feature in both at the same time. I'm not a programmer, but I would assume that coding this in a desktop version of the application has its unique set of complications from the web version.
-
Pawel Lachman
commented
For me it is still not available - however I count that it will be available soon.
However it concerns only WEB version - and in my case where we work together on the file with..5000 rows - web is not efficient enough, so it would be great if you can introduce it also for desktop app
-
Matt Peterson
commented
I just checked and it is still a feature for myself. I have a Business Premium license, if that information helps. It's also possible that things may vary from tenant to tenant as upgrades and features are rolled out.
Have you already tried clearing your browser cache/temp files? Maybe try using incognito mode in Chrome or InPrivate mode in IE to see if your experience changes. I'll use those modes myself to ensure I'm accessing O365 with a clean slate if I notice something is off.
-
Anonymous
commented
So I was able to use the feature for a week or so. Then, since Friday, it has disappeared. Is there some issue with it? Or are you making this some kind of premium feature or something?
