•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Temporary / Default Views aren't working as I expected
I have an online excel that has our customer terms in it, we want our customer service team of 10 to be able to use this excel and filter by the customer they're speaking with on the phone.
My understanding was that if you created a new view, you could filter and select without impacting other users, but that doesn't seem to be the case. The temporary/new/saved views are all controlling each other.
Inside is a dropdown, and once selected, all the other cells change.
Default view = select a customer = changes all other views to that customer
Temporary view = select a customer = changes all other views to that customer
Saved view = select a customer = changes all other views to that customer
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#self-service analytics tools
#financial modeling with spreadsheets
#self-service analytics
#Excel
#Temporary Views
#Default Views
#Saved Views
#Customer Service
#Customer Terms
#Online Spreadsheet
#Filtering
#Dropdown
#Customer Selection
#Cell Changes
#User Interaction
#View Management