Fix Excel for the Web Sheet View Filters Affecting the Default View
Question details
Keep each user's filters in a separate Sheet View without changing the default worksheet view.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Multiple users coauthor an Excel workbook stored on OneDrive and need to filter a worksheet independently.
- Observed behavior
- Filters created while using Sheet View unexpectedly affect the default view.
Open the OneDrive workbook in Excel for the web and confirm that each collaborator has permission to edit it. Identify the affected worksheet and ask users which Sheet View they have selected before filtering.
Create and select a separate Sheet View before filtering
Use this method to keep each collaborator's filter settings separate from the default view.
In OneDrive, select the workbook and open it in Excel for the web. Go to the worksheet you want to filter.
Select View > Sheet View > New. Confirm that the new view, rather than Default, is selected before changing any filters.
Use the filter arrows in the worksheet or select Data > Filter, then choose the values you want to display. Ask each collaborator to create and use a separate Sheet View.
Use the Sheet View controls on the View tab to keep or name the view if prompted. Switch to Default in the Sheet View selector and check that its filters are unchanged.

Check permissions and recreate the affected Sheet View
Try this if filters still affect the default view after users select separate Sheet Views.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move existing files. It does not fix Excel for the web Sheet View behavior.

Frequently Asked Questions
Why are my filters changing the default view?
You may be filtering while Default is selected instead of an individual Sheet View. In Excel for the web, check the Sheet View selector on the View tab before applying filters.
Can two users share the same Sheet View?
Users can select the same saved Sheet View, but changes to that view's filters can affect others using it. Create separate named views when users need independent filters.
How do I return to the default worksheet view?
On the worksheet, open the Sheet View selector on the View tab and choose Default.
What should I check if a new Sheet View still affects Default?
Check editing permissions in OneDrive's Share or Manage access settings, recreate the view, and verify that the workbook is not using legacy shared-workbook settings.




