How to Fix Excel Filters Not Working in SharePoint File Viewer
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.

- 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.
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.
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.
Navigate to the affected SharePoint page and click the 'Edit' button in the top right corner.
Select the existing File Viewer web part that contains the unresponsive Excel file and click the trash can icon to delete it.
Click the '+' icon to add a new File Viewer web part, then select your Excel workbook to connect it.
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.

Escalate to Microsoft 365 Support
If the issue persists across multiple files, browsers, and users, it likely requires backend investigation by Microsoft.
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. Install WPS Office: Download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet with zero formatting loss.
- 3. Share with Your Team: Use the WPS Cloud feature to generate a secure, collaborative sharing link, completely bypassing complex SharePoint web part setups.

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.




