Forum Discussion
Sheet View Issues with Excel Web Browser
Sheet Views in Excel Online are designed to let each person filter/sort without affecting others, but if someone applies filters outside of their saved Sheet View (or accidentally uses the “Temporary View”), those changes can spill over to everyone. The fix is to make sure each person explicitly enters their own named Sheet View before filtering, and to avoid using the default or temporary view.
You may consider:
1. Always switch to your own Sheet View first:
o Go to View > Sheet View.
o Select your named view before applying filters or sorts.
2. Avoid using the default view:
o If you see “Temporary View” at the top, click Keep View and save it under your name.
o This ensures changes stay private.
3. Lock down the process:
o Train your team to never filter in the default view.
o Encourage them to double-check the Sheet View indicator before making changes.
4. Clean up old views:
o If multiple temporary views exist, delete them and recreate clear, named views for each person.
Hi, thanks for your reply.
All users are going into their own Sheet View - I have checked this.
There are no Temporary views - I check this throughout the day and 1st thing in the morning when I am updating the data.
No filters are left applied once I have added the data in the morning before other users log on and go on to their own sheet view.
Still changes are happening, not all the time but sporadically which is why I am so stumped.
Every time a member of staff says something has changed, I view the changes and it says someone has 'Sorted' but when I have asked they haven't sorted anything. Even if they have 'Sorted' or 'Filtered' it should affect others views as they are all in their own sheets. I have even Video chatted people and changed certain filters within separate views but it doesn't change the opposite persons data which is what it should be doing.
It's driving us all crazy
I know its a new feature and maybe a few bugs with it but I have followed instructions to the letter of how to create, design and use the Workbook.
Anyone have any other ideas what the issue maybe?