1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Does advanced filtering work with sheetview?

Hello everyone I am trying to optimize the workflow of my company by using advanced filtering for the purpose of accelerating the work. That being said sometimes when I used the advanced filter in sheetview it changes the entire worksheet?

So what ends up happening is the following; in my sheet view (ChillrendsView) the original sheet is shown, however the master sheet is changed drastically and it shows the filter that I was trying to keep to myself.

Often times however I don't understand how this works, and if I go back to Default the entire sheet is now the filter that I applied, how do I revert this change and lastly

Is it even possible to use advanced filtering safely while, working with sheetviews?

submitted by /u/Chillrends
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article
Does advanced filtering work with sheetview?