Excel Performance Problems

Fix Excel Online Freezing When Filtering Large Tables

Amos GikundaAmos Gikunda Nov 2, 2026 869 views

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.

How to Fix and Report Excel Online Freezing When Filtering
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 you start

Before creating a reproduction file, ensure you have backed up your original workbook and completely removed any sensitive or confidential company data.

Solution 1Recommended

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.

1
Build a test workbook

Open a new blank workbook in Excel Online and generate dummy data to simulate a large table.

2
Replicate the exact conditions

Leave the first column empty, populate the subsequent columns with sample data, and apply data validation using an INDIRECT reference.

3
Save before filtering

Stop right before applying the final filter to the second column. Save the file or generate a shareable download link.

4
Submit the report

Share the sample file link with Microsoft Support. Include your browser version, tenant details, workbook size, and the exact steps to reproduce the freeze.

Create a Sample File and Report the Issue to Microsoft
Keep it simple: The sample file should take only three to five minutes to create. Do not include unnecessary formatting or scripts.
Free Microsoft Office alternative

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. 1. Download WPS Office: Install the free WPS Office suite on your computer.
  2. 2. Open your workbook: Open your problematic .xlsx file directly in WPS Spreadsheet.
  3. 3. Filter without freezing: Apply your filters to the large table; WPS Spreadsheet will process the INDIRECT references smoothly.
Free and lightweight alternative to Microsoft ExcelFully compatible with .xlsx, .xls, and .csv formatsHandles large tables and complex INDIRECT data validation smoothlyFamiliar user interface for a seamless transition
microsoft office alternative - wps office

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.