Forum Discussion
Remove or hide individual filters from individual columns
Why is it so hard to allow a developer to hide or disable filtering on some columns in a table? The arrow is ugly, when real estate is low and column widths are just wide enough to fit column names (...
mathetes, that video is a must watch for anyone who works with Excel. I have been using these formulas for some time now but while I knew how to use them I did not fully understand the logic and their implications.
Thank you for that.
While what you proposed is a work around, it involves the addition of yet another worksheet, requires a user to change worksheets to update data they notice is imperfect, and more vba to manage accessibility to the relevant sheets, it just boggles my mind why MS insist on adding advanced features that very few people will ever use while ignoring glaringly frustrating functionality. Just search for "remove specific filters" and you will find so many vultures who have "reassigned" the word "Remove" to imply "Clear" to grab traffic. Chat rooms are full of people needing this feature.
I have been writing in Excel and VBA for over 20 years and I love some of the evolving features but trying to produce software to support small business that is commercially stable and functional is getting harder.
I take, from your reply, that there is no documented way to do this?
Don't misunderstand I am a huge fan but Excel does so much more that crunch numbers, its capacity to develop whole of business software is incredible but it is never something that you could shrinkwrap and package for a client, it is always a "best I can do" result.
I keep being advised to create a request, it is getting progressively harder to find a launching point. I chatted with MS support 2 days ago and told them about a serious, duplicatable bug, that when triggered destroys data, they rolled my workbook back to a previous version prior the the trigger point. I then showed them how it would break again, their advice was don't do that. Don't refer to a sheet by it's ID? Are they serious?
I cannot imagine how many more people would try developing with Excel if it was more predictable I know my blood pressure would be a lot lower.
Thanks for your suggestion, REALLY appreciated that video.
Thank you for that.
While what you proposed is a work around, it involves the addition of yet another worksheet, requires a user to change worksheets to update data they notice is imperfect, and more vba to manage accessibility to the relevant sheets, it just boggles my mind why MS insist on adding advanced features that very few people will ever use while ignoring glaringly frustrating functionality. Just search for "remove specific filters" and you will find so many vultures who have "reassigned" the word "Remove" to imply "Clear" to grab traffic. Chat rooms are full of people needing this feature.
I have been writing in Excel and VBA for over 20 years and I love some of the evolving features but trying to produce software to support small business that is commercially stable and functional is getting harder.
I take, from your reply, that there is no documented way to do this?
Don't misunderstand I am a huge fan but Excel does so much more that crunch numbers, its capacity to develop whole of business software is incredible but it is never something that you could shrinkwrap and package for a client, it is always a "best I can do" result.
I keep being advised to create a request, it is getting progressively harder to find a launching point. I chatted with MS support 2 days ago and told them about a serious, duplicatable bug, that when triggered destroys data, they rolled my workbook back to a previous version prior the the trigger point. I then showed them how it would break again, their advice was don't do that. Don't refer to a sheet by it's ID? Are they serious?
I cannot imagine how many more people would try developing with Excel if it was more predictable I know my blood pressure would be a lot lower.
Thanks for your suggestion, REALLY appreciated that video.
I’m glad that video was both new and helpful. You’re clearly a more advanced user (as a developer for others, presumably as your work); I’m just a retired user, developing for myself. I also enjoy answering questions when I can. And then, too, I learn from watching what other pros do in this forum. Have learned a LOT in the last two years.