File Sharing Problems

Use Personal Filters in Excel on SharePoint While Co-Authoring

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Use Excel Sheet View for independent filtering

Use Sheet View when it is available to sort and filter without changing other co-authors' views.

1
Open the shared workbook

Open the workbook from its SharePoint library in Excel for the web or a supported version of Excel.

2
Create a Sheet View

Select the worksheet, then choose View > Sheet View > New. Excel opens a temporary view for that sheet.

3
Apply your filters

Use the filter arrows in the worksheet or table headers to select your assigned categories. Sort as needed within the Sheet View.

4
Keep or exit the view

On the View tab, choose Keep to save the temporary view, or Exit to return to the default view.

Use Excel Sheet View for independent filtering
Sheet View availability: Sheet View availability depends on your Excel version and where the workbook is stored. Without a separate view, worksheet filters and sorts may affect other collaborators.
Free Microsoft Office alternative

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.

Filter and sort worksheet data in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesNavigate a familiar, easy-to-use spreadsheet interfaceUse a lightweight office suite with a free option
microsoft office alternative - wps office

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.