Office Settings & Configuration

Fix Excel for the Web Sheet View Filters Affecting the Default View

Anum MushtaqAnum Mushtaq Nov 18, 2026 869 views

Question details

Keep each user's filters in a separate Sheet View without changing the default worksheet view.

Fix Excel for the Web Sheet View Filters Affecting the Default 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.
Before you start

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.

Solution 1Recommended

Create and select a separate Sheet View before filtering

Use this method to keep each collaborator's filter settings separate from the default view.

1
Open the workbook in the browser

In OneDrive, select the workbook and open it in Excel for the web. Go to the worksheet you want to filter.

2
Create a Sheet View

Select View > Sheet View > New. Confirm that the new view, rather than Default, is selected before changing any filters.

3
Apply filters in the new view

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.

4
Save and verify the 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.

Create and select a separate Sheet View before filtering
Saved views are not necessarily private: Other collaborators may be able to select a saved Sheet View. Use separate named views rather than having multiple users filter in the same view.
Free Microsoft Office alternative

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.

Filter spreadsheet data using a familiar interfaceOpen and edit Microsoft Excel XLSX and XLS filesMove existing spreadsheets into a lightweight office suiteUse familiar tools without starting from scratch
microsoft office alternative - wps office

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.