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?
Thank you for your continued feedback and responses. We are glad to update that the work for this feature has started.
We’ll share more details as we progress.
Johannes Bø commented
The Autosave solution works sometimes, but do not modify cells. The risk is that you get out of sync (conflicting error) and have to store the file in a different name (and have to redo everything).
I totally disagree that votes or activity make any difference to MS. They tell you to be sure to vote, that is the biggest line of ****! All you have to do is review the "Completed" category and you will see that those that have been completed have very few votes..........some with under 20 votes!
They pick and chose what they want to do and couldn't care less about the users. Very unfortunate that Excel was the top spreadsheet program and is now just a hangon outdated version being left in the dust by newer online options.
No personal views
Can't review cell changes
Can't use macros
and the list goes on....
At our company, I am reviewing a work around, it called G Suite..........
I have a workaround as well:
Whenever you need to use the filter, turn off the automatic saving option for the duration of your filtering. Just don't forget to click it back on when you're finished.
I suppose in the browser version this cannot be done, and it may not be the best solution for the desktop excel app either, but in some cases it is really helpful.
Johannes Bø commented
Message from MS Premier Support today:
"I completely understand your frustration, and I know for sure they are currently working on an optimal solution for it, it is proving to be a bit difficult however since there are multiple factors that are proving to be hard to work around. The direction they are taking is to create a view filter in Excel Online the way Lists in SharePoint work, but this will take time unfortunately.
If you do not mind however, I'd like to suggest a workaround that I've been using lately, which was working for me well.
In every Excel Online file where a user would like to filter and adjust to view the data better for himself, create a new Sheet, and call for example Karim's view Sheet. With the main sheet being strictly for data manipulation and restructuring and the other View sheets if for every user's desired filtering, sorting, custom calculation options. Of course, what may work for me, might not work for you, but I though you'd consider the suggestion."
I think they do take notice of this but obviously will react to the ones with most activity. If you can rally your colleagues (say using Teams or Yammer) to block vote in a short time span, this request is more likely to get the traction it deserves.
I can't tell you how many corporate processes are based on Excel in our company but it is in the thousands. Getting this co-authoring right should be a priority for MS so that faith is built with customers to adopt the newer elements of the O365 ecosystem.
And clown make-up.
Can't be the best unless you play the best: MS should BEG us to try alternatives, PAY alternatives, so their competition is the best and they can HAVE to be better. Oh, look, that idea's on the roadmap now! So... it ain't nevah gonna happen... (sigh...)
Clown nose too. Listen, it even beeps...
As an influencer, this thread has inspired me to revisit G Suite to see what it is capable of. It's not as if Microsoft offers some major reason to sway opinion such as great tech support or cohesion
between its products. They don't even pay attention to their own system for feature requests. They are clown shoes.
Well, several reasons for the not shifting seem possible. Maybe a million others too, but I bet these operate to a fair extent:
1) It's still a "No one ever got fired for buying Microsoft" corporate world. (Insert "IBM" and you have a "why" during the clone wars of the early to mid-80's. I suspect this one has been around as long as the "I'll never forget where I was when..." comments that date back to at least Pearl Harbor and surely before.) Bear in mind, it's not just "I won't go out on a limb" CYA think, many corporate to mid-size customers have a "relationship" they are "leveraging" with MS which they've paid, and are continuing to pay, large dollars for. ("Relationship" is sometimes rather like the one with Big Jim and the little scared guy in his cell... but these exist.)
2) Google has a LONG history of not being the least, not the freaking least, inhibited about simply dropping a product if they feel... well, whatever they feel... simply... it isn't there anymore. It never existed in the wild world outside their servers and therefore it doesn't exist now. Sometimes you have a period to adjust, sometimes you DON'T. Lots of folks are at least dimly aware of this and those who are more so are simply not willing to risk it. "It" being their jobs, their company's wellfare, their jobs, having a solution that will work tomorrow too, their jobs, well, you get the idea. That inhibits a Google solution.
3) Google is DEFINITELY "don't ask, don't tell" (the "tell" side of it) on a huge number of things but HUGELY SO when it comes to your privacy and in these cases, your data's privacy. They look at EVERYTHING that EVER comes through their machines, record anything they care too, analyze it all, and make money from it whether that includes sharing what any human being would clearly regard as private. 6¢ for giving away your secret formulas? Not worth seeking, but that company over there will examine the data for these nuggets and make the payments so why not? You betcha. I cannot imagine that that does not inhibit many corporate possible uptakers. Just a general, quiet (can't have the monster sue us) general policy of not using Google products or services. By the way, would YOU use Google's Password Wallet software offering? I thought not. (I won't either 'cause I made it up, but it was a chill-causer you're still shivering from thinking of how they could leverage that the way FaceBook leverages the "login with FaceBook idea, eh? Thinking of HAVING to use that Passsword Wallet or never login anywhere again... that's your heart shivering too friend.
4) The usual... I know Excel, and I don't know Google's "thing"... I mean, I wish I did, but I don't. I can't seem to get a chance to learn it either... this could be where I get left behind... but it still means I can't productively make the shift no matter how much productivity I lose with Excel... good thing I'm nearing retirement, right? And everyone else knows Excel. Excel works seamlessly (LOL, good Lord, LOL) with Word and there's no way Google does. Yeah. Power Point too, like if I need to update the Excel or Word source, it updates the PP slide too... oh, no, wait on that... but... everyone knows PP too. If I want to hire someone for data entry, they're flumoxed by the Google interface, I get nothing for a while, they do know Excel, well, they know how it looks and how to enter data in it... so knowledge for crafting and maintaining spreadsheets, knowledge by the bosses for using their dashboards and such (if you ain't got time to learn it, picture telling your boss he has to learn it or die with the dinosaurs... firing is still a thing you know), lower-level workers using it, general "taught in schools, even tests are taken in Word" kind of points... there's a lot for Google to overcome and it isn't making an effort on that fron either.
5) Google... you know, Biilionaire Gates ain't got a lot of sympathy from me for just about anything, BUT... My GOD the man has given an EXTRAORDINARY amount of that filthy lucre to charity. Continuing to. Google? Bezos? Buffet? Those Mexican cement lords? Billionaire Gates and by extension MS get a bit of a pass from me on things because the man does walk a (hu)man-size walk. I doubt many actively think about that, but I also bet huge numbers of us all are aware of it and give MS something of a pass on many things. (Lol, read some of my other posts here and elsewhere and you may need to remember there's a difference between pointing out room for improvement along with fears of nasty conspiracy-like marketing efforts vs. outright excoriation with a religous-liike intolerance for the thought anything could ever be improved along with a religious-like "anything I don't think is evil/wrong/sin/evil/wrong/sin" kind of idea.)
I think those operate to a fair extent—debate is allowed—and that many have many other reasons.
(Especially that "this may be where I may/will get left behind" one.)
Absolutely fascinating to follow this request. As a long-term user of Google Sheets which has long (maybe always?) offered this feature which (as everyone is indicating) makes working with shared documents a very powerful tool.
My guess is that Google built this in from the ground up, certainly we never have to think about savings/versions/syncing which still seems to be the way with MS.
I have my sympathy for MIcrosoft, it is probably very hard (without a full re-architecturing of the design) to achieve this. If you think about it, Google has one set of data that is accessible from anywhere/any device via the internet. So any client machine accessing the document is working with the core data store. Compare this with Microsoft who are still mixing local/sync/central copies. I predict even if they do get it going, it will be troublesome and likely to lose some updates due to timing of sync events etc.
I'll continue to watch this wish with interest, not least because I Wonder why any users (commercial or private) continue to stick with Microsoft when there are better, cheaper, more productive alternatives out there (that have proved to be stable for many years, even as more and more features are added).
Daniel Wübbold commented
We also need this feature very urgently!
It is important to have a timeline / roadmap for this feature as we will be aligning some processes afterwards.
GURPREET LALL commented
If this has been started on, then why do we not see it on the roadmap? Can we get an update on this? Not great for the business customers. Microsoft Premier Support are not able to help and are point us to vote on here!
What is the point if we do not get any updates?
Jerome Pellois commented
Any update ?
Tom G. commented
From the roadmap I cannot see this is progressing in anyway
Hopefully this "FILTER" is about the autofilter functionallity, which should be a personal view for each user working in a shared sheet.
We’ve added six new functions to use with Dynamic Arrays to supercharge your spreadsheets: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY.
Release Q3 2019..
Not sure if it is a this filter that we want
Tansu KAYRAK commented
In my company the perfectly working legacy sharing feature has been disabled from Excel. Now we are forced to use this new feature that is absolutely inconvenient. It would be great if this was fixed quickly (only the item 1 of the list). However I don't see anything coming on the roadmap despite the information provided in February.
Roadmap stuff is found here: https://www.microsoft.com/en-us/microsoft-365/roadmap
Funny how many people ask for a reply from MS, if you followed this treath a little you will notice MS doesn't care about small customers, they only help the top 100 big companies and the rest can be happy if something works.
We had mutiple issues with office 365 and their own website. We had to pay them for support to get their own website fixed. They don't care about small companies and rather have them go to Google instead.
I even got a presentation from a special Microsoft team that tries to help small companies describing these issues, it was actually funny to have them admit they suck in a presentation. (I got a digital copy from the guy)
If you want something to actually work go Google. If you want to have a greath laugh about how a company can stack shitpiles on each other go MS.
a user has no filter commented
_still problem is not solved by MS...sad!
_how many years more do you need?
_plus it is very astounding why this worked perfectly well up to Excel 365 and now it doesn't.
_I have always been of the assumption, that future version should make things better and easier and not vice versa...
Thomas Åsnes commented
How long time does it take from "started" to "completed" ?