Prevent Excel Sheet Views From Changing the Default View
Question details
Keep the Default Sheet View unchanged while multiple users apply their own filters to a shared Excel worksheet.

- Product
- Microsoft Excel Sheet Views
- Device & OS
- not provided
- Scenario
- Multiple users work in a shared workbook stored on OneDrive and need personal worksheet filters.
- Observed behavior
- Filters or sorts applied while the Default view is active can change the shared default view.
Confirm that the workbook is saved in OneDrive or SharePoint and that each collaborator uses a version of Excel that supports Sheet Views. Open the shared worksheet and check the current view on the View tab before applying filters.
Have each user filter in a separate Sheet View
Use a personal Sheet View to apply filters or sorts without changing the Default view.
Open the workbook from OneDrive or SharePoint in a supported version of Excel, then select the worksheet you want to filter.
Go to View > Sheet View and select New, or choose your existing named view from the Sheet View menu.
If you created a temporary view, select Keep in the Sheet View controls and give the view a name so you can return to it later.
With your named Sheet View active, use the column filter arrows to filter or sort the worksheet. Ask each collaborator to select their own view before doing the same.
Before filtering again, open View > Sheet View and confirm your named view is selected rather than Default.

Work with shared spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar spreadsheet interface and support for Excel formats, making it easier to move existing workbooks. It does not fix Microsoft Excel Sheet View behavior.

Frequently Asked Questions
Why did the default worksheet view change?
A collaborator may have applied a filter or sort while the Default view was active. Each user should select or create a personal view under View > Sheet View before filtering.
How do I return to my personal Sheet View?
Open the worksheet, go to View > Sheet View, and select your named view from the menu before applying filters or sorts.
Why can't I find Sheet View in Excel?
Check that the workbook is saved in OneDrive or SharePoint and that your Excel version supports Sheet Views. Then look for Sheet View on the View tab.
Do Sheet Views prevent other people from seeing my cell edits?
No. Sheet Views separate viewing and filtering arrangements, not workbook data edits. Changes to cells can still be shared with other collaborators.




