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!
678 comments
-
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?
-
Markus
commented
Finally! Have been waiting for this one a long time, but will it be avaible in desktop mode too? Our companyfiles are a bit on the heavy side for Excel Online.
-
Don S
commented
Wes,
I don't know exactly how big your group is or what you are trying to accomplish, for for relatively small groups (~<20) you can give everyone their own tab with their own table and then pull them all together into one large aggregating table. That's what I have done with up to a dozen of our project managers who all want to work on the same file in such a way that all the info can be reviewed by the manager at the same time... If you'd like help setting up something like that feel free to contact me at dons [at] premierconstructionspreadsheets {dot} com -
Ben
commented
Still waiting for Sheetview to be enabled. Any idea when the roll out will be completed?
-
Wes A
commented
I'm having trouble with the new Sheet Views :(
1. Because my sheet is protected (to prevent people from accidentally overwriting calculated cells, etc.), and even though the protection includes the right to use the filters, the Sheet View apparently does not work because "This sheet is protected. Some parts may be view-only and can't be changed". I feel this is an oversight by Microsoft and needs to be fixed.
2. Using Sheet Views does not restrict editing to only the visible cells. For example, if I filter down a column by "Claim", and several rows disappear from the view, if I paste in a vertical list from another sheet, those will write to the hidden cells. I understand this behavior happens with regular autofilters as well, the intent with Sheet Views, I thought, was to allow people a safe way to work with data they were concerned with while other users would not be affected.
Frustrating! Sheet Views does not help my group at all. I was telling them "just wait several months, just wait another month, another week..." and now I have to tell them "sorry, you're out of luck guys!" - unless of course, this gets fixed.
Side note, anyone CAN create their own filter view and even save it, but if anyone tries to open one that was already saved, it fails with that error message above! Odd behavior indeed - hope MS sees this and has a quick fix. -
Martin S.
commented
Finlay have this feature. I didn't need to do anything to get it.
-
Anonymous
commented
Build # 16.0.12430.35903 has the view
-
Luke
commented
Can someone with access to this feature please share your excel online build ID?
Mine is 16.0.12429.37951 and I don't have access to Sheet Views.Wondering if this has been rolled out already or if I need to do anything to "upgrade"?
-
Anonymous
commented
Highly required this feature
-
Marc
commented
Highly expecting this feature to be available to all! Thanks!
