Excel Filter Not Working in SharePoint? Causes and Fixes

If a filter is not working in Excel in SharePoint, first check that the filter covers the full data range, then clear and reapply it using Data > Filter. A protected sheet, a shared view, or a mismatch between the browser and desktop app can also explain why the filter is missing or appears not to work.

Why Excel filters behave differently in SharePoint

SharePoint stores and shares the workbook; the filtering itself is handled by Excel, either in Excel for the web or in the Microsoft 365 desktop app. Basic filtering works in both, but the workbook may be open in different modes, and collaborators may be viewing or changing it at the same time. That can make a filter look inconsistent even when the data has not changed.

It helps to identify the exact symptom. A missing arrow usually points to the filter being off, an incomplete selection, or a protected worksheet. An arrow that appears but returns unexpected rows is more often caused by blanks, inconsistent data, or a filter applied to the wrong range. If the rows change for one person but not another, check whether they are using separate Sheet Views.

Try these quick checks first

Confirm that you can edit the workbook. If it is open read-only or in a viewing mode, switch to editing if you have permission. A person with view access may be able to inspect the file but cannot necessarily change its filter state.
Click a cell inside the data and look for filter arrows in the header row. In Excel for Microsoft 365 on Windows, choose Data > Filter to turn filtering on or off. Ctrl+Shift+L is the Windows shortcut. In Excel for the web, use Data > Filter if the ribbon command is available.
Clear the current criteria from the column dropdown, or use Data > Clear to clear filters across the range. Then open a dropdown again and choose a value you know is present.
Check for a message that the worksheet is protected, and ask whether someone else has a filter or sort applied in a shared view.
If the browser still behaves unexpectedly, save the workbook and choose Open in Desktop App. Compare the result there before changing the data or rebuilding the workbook.

These checks are useful because they separate a disabled control from a filter that is active but selecting the wrong set of rows. Avoid deleting rows or changing source values until you know which problem you are solving.

Make sure the filter includes the whole data set

Excel filters a range, not every cell that happens to look like part of a table. If the selected range stopped before the last rows or columns, records outside it will remain visible and may appear to ignore the filter. A blank row or blank column inside the data can also cause Excel to treat one continuous data set as separate regions when it guesses the range.

For a dependable setup, keep one header row, place records directly below it, and avoid completely blank rows or columns within the list. Click a cell in the data and inspect the filter arrows: each relevant header should have a dropdown. If the list is a regular range, select the intended data, including headers, then choose Data > Filter. On Windows, Ctrl+Shift+L toggles AutoFilter for the selected region; check the resulting arrows rather than assuming Excel selected every record.

For data that grows regularly, convert the range to an Excel table. Select a cell in the data and use Insert > Table, confirm the range and whether it has headers, then select OK. Tables include filter dropdowns in their header row and generally expand as new rows are added immediately below them. Before creating a table, verify that the proposed range includes all records and that the header names are in a single row. In Excel for the web, the Table command is also available from the ribbon, though the layout can vary with the window size.

Merged cells in a data area, repeated header rows, or a title above the actual column names can make filtering harder to set up correctly. Keep titles outside the filtered range, and use unique, nonblank labels such as “Date,” “Region,” and “Order status” for the header cells.

Check worksheet protection and editing access

When a sheet is protected, the filter arrows may be unavailable or users may be unable to change filter criteria. In the desktop app, check Review > Unprotect Sheet. If the command asks for a password, only someone authorized to manage the workbook should provide it; do not try to bypass the protection.

A sheet owner can configure protection to allow users to use AutoFilter. In Excel for Windows, the protection dialog is available through Review > Protect Sheet. The owner should review the permissions in that dialog, including the option for using AutoFilter, before protecting the sheet. Existing filters and permission behavior can depend on how the sheet was protected, so test the intended user actions after making the change. Excel for the web may not expose every protection setting; use the desktop app when the needed option is not available in the browser.

SharePoint permissions matter too. A workbook opened read-only can still be useful for viewing, but users without edit rights cannot make lasting changes to the workbook. If you can select a filter but cannot save a change, check the sharing link and your access with the file owner rather than assuming the filter feature is broken.

Understand filters in a shared workbook

When several people work in the same workbook, sorting or filtering in the default sheet view can affect what colleagues see. Excel’s Sheet View feature is designed to let people sort and filter without changing the view other collaborators are using. In Excel for Microsoft 365 on Windows, choose View > Sheet View > New, then apply the filter. Excel for the web also provides Sheet View from the View tab when the feature is available for that workbook.

If another person’s changes seem to undo yours, check the Sheet View menu and the view indicator before repeatedly applying the filter. You may be in the default view, or you may have returned to a shared view. Sheet Views are most useful when people need different ways to inspect the same records—for example, one colleague filtering orders by “Pending” while another looks at “Shipped.” They do not create separate copies of the data, and changes to the underlying cells are still changes to the shared workbook.

For important reporting, agree on whether a filter should be personal or visible to everyone. If collaborators need the same result, use the default view and coordinate before changing it. If each person needs a different result, use a separate Sheet View where supported. A saved filter state is not the same thing as a separate dataset or a security boundary: hiding rows with a filter does not prevent other users with access from viewing the underlying records.

Compare Excel for the web with the desktop app

Excel for the web supports ordinary sorting and filtering, so basic filters should not require a desktop installation. However, the browser interface can differ from the Windows ribbon, and some workbook features or protection settings may be easier to inspect in the desktop app. A feature or display issue in one environment is not proof that the workbook data is damaged.

To compare, save your changes, then use Open in Desktop App from the SharePoint or Excel interface. In desktop Excel, verify that the correct worksheet is active, that the filter arrows are present, and that the expected rows appear. If it works in the desktop app but not in the browser, refresh the browser page after confirming the workbook has saved, or try a current supported browser. If it fails in both, focus on the range, protection, and data consistency rather than browser settings.

On Mac, the ribbon commands may be arranged differently, but the filter controls are still available from the Data tab in current Excel versions. If a keyboard shortcut differs or is intercepted by macOS, use the ribbon command instead. The exact browser menus can also shift as Microsoft updates Excel for the web, so use the named tab and command rather than relying on a particular screen position.

Look for inconsistent values and hidden records

A filter can be working correctly while its results surprise you. For example, a column may contain “North,” “North ” with a trailing space, and “NORTH.” Depending on the operation and displayed choices, these values may not behave as the user expects. Similarly, dates stored as text can sort or filter differently from real Excel dates, and numbers stored as text may not match numeric criteria as anticipated.

Open the column dropdown and review the available values and filter options. If a value is missing, clear the filter first and inspect the source cells for extra spaces, inconsistent spelling, blank cells, or mixed data types. In a date column, confirm that cells are actual dates rather than text that only looks like a date. Do not assume that a filter automatically normalizes inconsistent data; correcting source values may be necessary, and changes should be checked with the workbook owner if the file is shared.

Also distinguish filtered-out rows from hidden rows. A manually hidden row can remain hidden even after a filter is cleared, making it seem as if the filter failed to restore every record. Check the row-number sequence and use the sheet’s Unhide command if you are authorized and need to reveal manually hidden rows. A filter only controls which records are displayed according to its criteria; it does not erase excluded records.

Save, refresh, and troubleshoot synchronization

Excel for the web saves supported edits to the workbook in SharePoint, but a change may take a moment to appear for collaborators. Look for a saving or saved status before closing the tab. If the page appears stale, refresh only after confirming that your edits have finished saving; refreshing during an unsaved change can risk losing work.

When a filter seems stuck, use a small, reversible test: choose a value that occurs in several rows, confirm the visible records, then clear the filter. If the result differs between users, ask both people to identify the active worksheet and Sheet View and whether they opened the file in a browser or desktop app. This gives the file owner concrete information without requiring a broad reset.

Do not delete or move rows just to make the filter dropdown reappear.
Do not remove protection or change SharePoint permissions unless you are authorized to do so.
Before making structural changes, save a copy or ask the owner to confirm the workbook’s intended layout.
If the issue affects only one browser session, reload after saving and compare with another supported browser or the desktop app.

Frequently Asked Questions

Why are the filter arrows missing in Excel on SharePoint?
Filtering may be turned off, the selected range may not include the headers, or the sheet may be protected. Click inside the data, check Data > Filter, and confirm that the header row is part of the range.

Why does my filter not show all the rows?
The filtered range may exclude later rows, or blank rows may have split the data into separate regions. Clear the filter, check the range boundaries, and look for manually hidden rows or inconsistent values.

Can other people see my filter in a shared Excel workbook?
They may see changes made in the default sheet view. Use View > Sheet View > New when available to work with a separate view, and remember that a filter hides rows but does not restrict access to the data.

Can I filter a protected worksheet?
That depends on how the owner configured sheet protection. The owner can allow AutoFilter use when protecting the sheet. If you do not have permission to change protection, ask the owner to adjust it.

Should I open the workbook in the desktop app?
Try it when the browser command is missing, protection settings need inspection, or the browser result seems inconsistent. Basic filtering is supported in Excel for the web, so switching apps is a diagnostic step rather than a required fix.

Does clearing a filter delete the hidden records?
No. Clearing a filter changes which records are displayed; it does not remove the excluded rows. If rows remain missing afterward, check for manual hiding, another active filter, or a range that does not include them.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.