This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi there,
My Team is working on large Excel sheet with various team updating data on the sheet.
I have applied Excel Sheet View, so each team can quickly apply filters for the rows of data that relate to them without the need of clearing the filters of others, etc.
However, when Team 1 select its own Excel Sheet View and then for some reason started changing filters (without changing the view) there is no prompt or warning message from Excel that filter set up is being changed and then next time someone else use Team 1 sheet view the filters are all changed (not as intended and originally set up).
Can the change of saved sheet views filters be blocked somehow (e.g. Team 1 filters) or the message warning the user that it will change the set up filters?
Many thanks for your help.
Chris
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This is no such settings to lock sheet view filters. However, this is a good idea. I will send it to relevant team. Hope Microsoft will add it in the future.
From your description, is it possible to create more sheet views for each user? Such as team 1 User A, Team 1 user B.