Use Excel Sheet Views for Independent Filters in SharePoint
Question details
The user wants multiple people editing a shared Excel workbook in SharePoint to filter and sort independently without affecting each other's view.
- Product
- Microsoft Excel for the web (SharePoint)
- Device & OS
- not provided
- Scenario
- A team collaborates on a shared Excel workbook hosted in SharePoint and needs independent filters and sorts.
- Observed behavior
- A standard filter or sort applied by one user changes the view for every collaborator.
Open the shared workbook in Excel for the web and make sure you have edit permission. You do not need to turn off AutoSave, because Sheet Views are saved per user.
Create a Sheet View in Excel for the Web
Use this solution when several people work in the same SharePoint-hosted workbook and each person needs their own filters or sorting without interrupting others.
Sheet Views are temporary, user-specific views available in Excel for the web. They keep AutoSave enabled and do not alter the underlying data or other people's display.
In SharePoint, open the shared Excel file and wait for it to load in the browser.
On the ribbon, click the View tab to reveal workbook view options.
In the Sheet View group, click New Sheet View. The worksheet briefly refreshes and the view name becomes temporary, such as View1.
Use the column filter arrows or Data > Sort to create the independent filter or sort arrangement you need.
Optional: Click the view name in the Sheet View group, type a meaningful name, and press Enter. Changes are saved to your view only.
Switch, Reset, or Exit a Sheet View in Excel for the Web
Use this solution to return to the default view, switch between saved Sheet Views, or discard temporary views.
Switch to WPS Office for Lightweight Spreadsheet Collaboration
Sheet Views are a Microsoft Excel for the web/SharePoint feature. If you want a free Office suite that opens, edits, and saves .xlsx files with familiar tools, WPS Office is a lightweight, easy-to-use alternative for spreadsheet work.
Frequently Asked Questions
Are Sheet Views available only in Excel for the web?
Sheet Views are available in Excel for the web. Some desktop Excel versions may not show the same Sheet View controls, so open the workbook in a browser and use View > New Sheet View.
Will my filter in Sheet View change what others see?
No. Sheet Views are user-specific displays, so filters and sorts affect only your current view and do not change other collaborators' views.
Can I use Sheet Views while AutoSave is on?
Yes. Sheet Views are designed to work with AutoSave enabled in Excel for the web, so you do not need to disable AutoSave before creating a view.
How do I return to the normal view?
Go to the View tab, click the current view name in the Sheet View group, and choose Default View or Exit to return to the normal workbook view.
Can WPS Office create Sheet Views in SharePoint?
Sheet Views are specific to Excel for the web in SharePoint. WPS Office can open and edit .xlsx workbooks with familiar filter and sort tools, but the SharePoint Sheet Views interface is not available in WPS Office.
