Forum Discussion
Excel 365 Sheet Views are not working
Of course, it is clear to me that Excel is constantly evolving.
I also realize that I am not the best person to give a 100% answer (I pointed this out at the beginning).
I also realize that it took this user, months to get a response.
It is also clear to me that if I give an answer in an area that I have very little idea, I have to be very careful with my wording and pass on the information as far as possible from links.
My principle, everyone has the right to an answer, even if it is not 100%.
Better a vague answer than none at all.
My principle, rather to show a community member that you are here, even if you are not 100% the right one, than that the user feels left alone in the vast universe of Microsoft.
My principle is that what you feel is not a fact, but if you ignore it, it becomes a fact.
To end, if you ask me or ask me not to answer something that is not 1000% correct, then I can only answer ... NO, I will answer even if im not 100% sure.
At the same time you would have to delete 80% of the messages because they are not 100% correct.
I haven't seen in any chat forum until now that the Pareto principle has been applied.
Anyway that's just my humble opinion, but who am I that I have the infallible and am not wrong?
Thanks for your time and understanding.
Nikolino
NikolinoDE your answer was to copy and paste from the https://support.microsoft.com/en-us/office/sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6.
The frustration isn't because your answer is right or wrong, its because what you posted is literally useless. The person who asked the question and anyone coming here with the same issue hoping to find an answer obviously already knows what Sheet Views in Excel is and would've already read that page.
- NikolinoDEJan 16, 2022Platinum Contributor
If I may recommend, report your concern/problem in a description below these pages.
Think this will help you and maybe others more if this is a common topic.
How do I give feedback on Microsoft Office?
I know that it is annoying when you have a problem and instead of an answer you get more questions. But please consider the possibilities in Excel are very diverse, as are the possibilities of the causes.
I hope that your issue will be resolved quickly and that you will have a lot of fun with Excel.
Thanks for your comments, they might help others as well.
I know I don't know anything (Socrates)
- nirad1595Jan 15, 2022Copper ContributorThis is a buggy, half-baked feature released by MS - ridiculous. If you set up a sheet view and then exit it (go to default view), Excel still thinks there is a filter enabled. This prevents the user from moving around columns or doing anything that is prohibited in filtered views. There is no way to clear the filter from the "Sort & Filter" menu - "Clear" shows up as an option, but when the user clicks it, it does not clear the filter. Bottom line, Excel thinks there is a filter set when there is nothing being filtered. The only workaround is to exit and open Excel again. Crazy this is such a major bug so long after release! Apparently MS does not care to address this.
- NikolinoDEDec 17, 2021Platinum Contributor
What I have posted is nothing different from what Microsoft has on its pages. If that is useless, then my link and infos are also useless (as you saw it - which I did not hide – it is exactly the same information).
If you didn't like it, please ignore it, comments of this kind do not help our mutual help here in the forum.
I can understand that the frustration can be very high when a problem arises that usually appears at the worst time. Nevertheless, I can't and don't want to understand why a person can be rude and take the help offered to him (even if it may be so "useless" for him) as annoying.
I am not a Microsoft employee and have no direct or indirect business dealings with Microsoft. I don't want to distinguish myself in any way or benefit. Am a simple user, nothing else.
I try to give my help here in the forum (as far as this is possible and does not add any harm) because I have also received help here in this wonderful forum and also get it whenever I need it in Excel.
In this forum, a user gets help from other users in advance. If a user thinks he needs professional help, he can also contact Microsoft Support directly. With the appropriate account and investment, of course.
Here you have received a link from me that maybe can shows for the user the way to this info or that this might also help.
As I said at my previous posts "Please do not forget, I am a layman when it comes to Excel Web, all information without guarantee ... because I know that I know nothing".
If you find my comments annoying, please do not pay attention to them and if you want to, do not pay attention to me either.
I will do the same by trying do not pay attention any future questions from you.
Life is short, but we always have time for politeness, because politeness is a virtue ... a virtue where we don't need talent, just politeness.
It is a shame that these days are not used to see "in us" before we look around and above us.
I also wish you reflective days with health and joy.
Thank you for your patience and time.
NikolinoDE
I know I don't know anything (Socrates)