Forum Discussion
Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing.
The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!!
My excel and computer Skills aren't excellent to please any simple advise would be great.
2 Replies
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?
