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?
[link] [comments]
Want to read more?
Check out the full article on the original site