Use Personal Filters in Excel on SharePoint While Co-Authoring
Question details
The user needs to filter a shared Excel workbook independently while others co-author it.
- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Multiple users edit a workbook stored on SharePoint and each needs to see a different set of rows.
- Observed behavior
- Filtering or sorting the shared worksheet can change the view for other collaborators.
Open the workbook from SharePoint in a version of Excel that supports Sheet View, and check for Sheet View on the View tab. Confirm whether you are working with an Excel workbook or a SharePoint list, since they use different view controls.
Use Excel Sheet View for independent filtering
Use Sheet View when it is available to sort and filter without changing other co-authors' views.
Open the workbook from its SharePoint library in Excel for the web or a supported version of Excel.
Select the worksheet, then choose View > Sheet View > New. Excel opens a temporary view for that sheet.
Use the filter arrows in the worksheet or table headers to select your assigned categories. Sort as needed within the Sheet View.
On the View tab, choose Keep to save the temporary view, or Exit to return to the default view.

Create a personal view for a SharePoint list
Use this approach for a SharePoint list, not for an Excel workbook stored in a library.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Excel-format compatibility for an easy transition. Use WPS Spreadsheets to work with workbook data; it does not resolve Excel's SharePoint Sheet View availability.

Frequently Asked Questions
Will my Sheet View filters change what other co-authors see?
Filters and sorts applied within your Sheet View do not change other users' views. Create one from View > Sheet View > New before filtering.
What if I don't see Sheet View in Excel?
Check that the workbook is stored on SharePoint or OneDrive and open it in Excel for the web or a supported Excel version. If Sheet View is unavailable, shared worksheet filters may affect other users.
Can I save my Excel Sheet View for later?
Yes. After creating a temporary Sheet View, select View > Sheet View > Keep and give the view a name.
Is a SharePoint list view the same as an Excel Sheet View?
No. A personal SharePoint list view controls how you see list items; an Excel Sheet View controls your view of a worksheet. Use the list's view menu for a list and Excel's View tab for a workbook.




