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

Tagged with

#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#advanced filtering
#sheetview
#workflow optimization
#filter
#worksheet
#master sheet
#data filtering
#ChillrendsView
#revert changes
#filter application
#default view
#user experience
#sheet manipulation
#user query