Fix Excel Online Freezing When Filtering Large Tables
Question details
The user needs to reproduce and report a persistent freezing issue in Excel Online when attempting to filter columns in a specific data setup.

- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Filtering the second column of a large table that contains an empty first column, populated subsequent data, and data validation using an INDIRECT reference.
- Observed behavior
- Applying the filter fails and causes the entire Excel Online workbook to freeze within the browser.
Before creating a reproduction file, ensure you have backed up your original workbook and completely removed any sensitive or confidential company data.
Create a Sample File and Report the Issue to Microsoft
Since this is a specific bug related to INDIRECT references and filtering in the web browser, creating a clean reproduction file helps Microsoft isolate and fix the problem.
To prevent confusion regarding tenant corruption, it is best to build a fresh sample file from scratch. This allows the Excel Online engineering team to trace the exact calculation chain failure.
Open a new blank workbook in Excel Online and generate dummy data to simulate a large table.
Leave the first column empty, populate the subsequent columns with sample data, and apply data validation using an INDIRECT reference.
Stop right before applying the final filter to the second column. Save the file or generate a shareable download link.
Share the sample file link with Microsoft Support. Include your browser version, tenant details, workbook size, and the exact steps to reproduce the freeze.

Use Alternative Filtering Methods
Avoid the browser freeze by modifying your data structure or utilizing the desktop application.
Use WPS Spreadsheet to Avoid Browser Freezes
If Excel Online is consistently freezing during complex filtering tasks, switch to WPS Spreadsheet. It offers a lightweight, highly compatible desktop alternative that handles large datasets and advanced data validation smoothly without browser-based memory limitations.
- 1. Download WPS Office: Install the free WPS Office suite on your computer.
- 2. Open your workbook: Open your problematic .xlsx file directly in WPS Spreadsheet.
- 3. Filter without freezing: Apply your filters to the large table; WPS Spreadsheet will process the INDIRECT references smoothly.

Frequently Asked Questions
Why does Excel Online freeze when filtering?
Browser memory limits and complex calculation chains, particularly with INDIRECT data validation references across large tables, can overwhelm the web version of Excel and cause it to stop responding.
Does this filtering issue affect the desktop version of Excel?
Generally, no. The desktop application utilizes your computer's full processing power and handles complex INDIRECT references and large table filtering much better than the web-based version.
How do I share a reproduction file safely?
Create a new workbook, use only dummy text or random numbers, ensure the freeze still occurs, and then share it via a secure OneDrive or SharePoint link with Microsoft Support.




