SharePoint Document Issues

How to Fix Excel Filters Not Working in SharePoint File Viewer

Ayan MasoodAyan Masood Nov 3, 2026 868 views

Question details

Users are unable to use Excel column filters within the SharePoint File Viewer web part, despite the filters working normally when the file is opened directly.

How to Fix Excel Filters Not Working in SharePoint File Viewer
Product
SharePoint / Microsoft Excel
Device & OS
not provided
Scenario
Viewing and interacting with an Excel workbook embedded on a SharePoint page using the File Viewer web part.
Observed behavior
Excel column filter arrows appear in the web part but are locked or completely unresponsive. No error messages are displayed, and the issue affects multiple users, files, and browsers.
Before you start

Ensure you have edit permissions for the SharePoint page so you can modify or replace web parts. It is also helpful to know whether your Excel file was uploaded directly from your computer or linked from a SharePoint document library.

Solution 1Recommended

Re-add the File Viewer Web Part and Test Browsers

Refreshing the web part connection and isolating browser-specific glitches can resolve temporary locking of Excel filters.

Sometimes the connection between the SharePoint page and the Excel file becomes corrupted, causing interactive elements like filters to freeze. Re-adding the web part forces SharePoint to render the file fresh.

1
Edit the SharePoint Page

Navigate to the affected SharePoint page and click the 'Edit' button in the top right corner.

2
Remove the Web Part

Select the existing File Viewer web part that contains the unresponsive Excel file and click the trash can icon to delete it.

3
Add a New Web Part

Click the '+' icon to add a new File Viewer web part, then select your Excel workbook to connect it.

4
Test in a Different Browser

Publish the page and test the filters. If they still fail, open the page in an alternative browser (such as Microsoft Edge instead of Chrome) to rule out browser caching issues.

Re-add the File Viewer Web Part and Test Browsers
Check the File Source: Test uploading a fresh copy of the file directly from your local computer versus selecting it from an existing SharePoint Document Library to see if the file's storage location affects filter functionality.
Free Microsoft Office alternative

Use WPS Office for Reliable Spreadsheet Management and Sharing

If you frequently encounter integration issues and broken features within SharePoint and Excel web parts, consider WPS Office. It provides a lightweight, highly compatible alternative for creating, editing, and sharing spreadsheet data seamlessly with your team.

  1. 1. Install WPS Office: Download and install the free WPS Office suite on your device.
  2. 2. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet with zero formatting loss.
  3. 3. Share with Your Team: Use the WPS Cloud feature to generate a secure, collaborative sharing link, completely bypassing complex SharePoint web part setups.
Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Built-in cloud collaboration and easy link sharing for teams.Lightweight installation with a familiar, user-friendly interface.Free to use with powerful data filtering and analysis tools.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel filters work in the desktop app but not in the SharePoint File Viewer?

The SharePoint File Viewer web part renders a lightweight, browser-based preview of the Excel file. Complex formatting, specific table setups, or temporary server-side rendering glitches can cause interactive elements like column filters to become unresponsive in this preview mode, even though the source file is perfectly fine.

Does the source of the Excel file affect how it behaves in SharePoint?

Yes, files uploaded directly from a local hard drive to the File Viewer web part can sometimes behave differently than files that are hosted in a SharePoint Document Library and linked to the web part. Testing both upload methods is a standard troubleshooting step.

Can viewers without edit permissions use filters in the File Viewer web part?

Under normal circumstances, viewers can interact with column filters in the web part to sort and search data without altering the original file. If filters are locked for everyone, including page editors, it indicates a technical rendering issue rather than a permissions restriction.

How can I share an Excel file if the File Viewer web part remains broken?

As an immediate workaround, you can use the 'Embed' web part with an iframe code generated from Excel for the Web, or simply provide a direct shared hyperlink to the document on the SharePoint page so users can open it directly in their browser where filters function normally.