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. Th...
Hi climo2k,
You’re right that Sheet Views in Excel for the Web are designed so each person can filter or sort without affecting others. If filters are still changing for everyone, it usually means someone is applying them in Normal View instead of their own Sheet View. A few tips that should help:
- Always enter your Sheet View first: Go to View → Sheet View → select your view. At the top you should see a black bar that says “You’re in a Sheet View”. If you don’t see that, you’re in Normal View and any filters will affect everyone.
- Save the view: After creating a Sheet View, make sure it’s saved. Otherwise Excel may drop back to Normal View.
- Temporary views: If someone just wants to do a quick filter, Excel will often prompt them to use a temporary Sheet View. They should accept that prompt so their changes don’t spill over.
- Name views clearly: Give each view a clear name (e.g. “John’s View”, “Finance Filters”) so people know which one to pick.
- Train the team: Remind everyone to check the black bar before filtering or sorting. That one step prevents most of the issues you’re seeing.
If the workbook is very large and you still run into problems, you might consider breaking it into smaller linked files or using tools like Power BI or SharePoint Lists, which handle multi‑user filtering more smoothly.