Excel Performance Problems

How to Reduce Excel File Size and Stop Workbook Freezing

Ayan Masood Oct 10, 2026 868 views

Question details

The user needs to reduce the file size of a large Excel workbook that freezes, buffers, and is too large to share.

How to Reduce Excel File Size and Stop Workbook Freezing

Product: Excel
Device & OS: not provided
Scenario: Editing, saving, and emailing a large spreadsheet.
Observed behavior: The workbook constantly freezes, buffers, and remains too large to send via email even after saving it in a binary format.

Before you start

Create a copy of your original workbook before deleting rows, columns, or formatting to ensure no critical data is accidentally lost during the cleanup process.

Solution 1Recommended

Locate and Delete Unused Cells to Reset the Last Cell

Excel often tracks empty rows and columns as part of the active sheet, which severely bloats the file size. Deleting them is the most effective fix.

A common cause for large file sizes is columns or rows containing formatting or invisible characters that do not calculate anything but are still processed by Excel. Resetting the 'last used cell' forces Excel to ignore these blank spaces.

Find the last used cell

Open your worksheet and press Ctrl + End. This will jump to the last cell Excel currently recognizes as containing data or formatting.

Select unused rows

If the last cell is far below your actual data, click the row number right below your last row of real data, hold Ctrl + Shift + Down Arrow to highlight all unused rows to the bottom of the sheet.

Delete the rows

Right-click the highlighted row headers and select 'Delete'. Do not just press the Delete key, as that only clears content, not the rows themselves.

Repeat for columns

Select the first empty column header to the right of your data, hold Ctrl + Shift + Right Arrow, right-click the headers, and select 'Delete'.

Save the workbook

Save the workbook immediately. The file size and loading time should be significantly reduced.

Locate and Delete Unused Cells to Reset the Last Cell

Solution 2

Change Calculation Settings to Manual

If formulas are causing delays and buffering, setting calculations to manual stops Excel from processing the entire workbook after every edit.

Solution 3

Remove Hidden Content and Unnecessary Formatting

Hidden sheets, complex custom formatting, and unoptimized high-resolution images can dramatically increase file size.

Easily Manage Large Spreadsheets with WPS Office

WPS Spreadsheet provides powerful tools to manage large files smoothly. You can easily clear unneeded formatting, shrink file sizes, and enjoy faster loading times without the freezing issues.

1. Open your large file in WPS: Launch WPS Spreadsheet and open your bloated or freezing Excel workbook.
2. Locate excess data: Press Ctrl+End to quickly jump to the last active cell and identify excess blank rows and columns.
3. Delete empty rows and columns: Highlight the unused columns and rows beyond your actual data, right-click the headers, and select 'Delete'.
4. Save as a compressed format: Go to Menu > Save As, and choose a compressed format like .xlsb (Binary) to dramatically reduce the file size.

Highly compatible with Microsoft Excel (.xlsx, .xlsb) formats.Lightweight software architecture that handles large datasets efficiently.Built-in file optimization features to keep your spreadsheet running fast.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel file huge even though there is very little visible data?

Excel may be remembering 'ghost' formatting or empty cells far beyond your actual data. Pressing Ctrl+End will show you the last cell Excel is tracking; deleting the blank rows and columns between your data and this cell will shrink the file.

Does saving an Excel file in binary format (.xlsb) reduce its size?

Yes, saving a workbook as an Excel Binary Workbook (.xlsb) can significantly reduce file size and improve loading speeds compared to the standard .xlsx format, though it will not fix underlying bloat from thousands of unused formatted cells.

How do Pivot Table caches affect workbook performance?

Pivot tables save a background copy of the source data known as the cache. If you have multiple pivot tables based on the same data but created them separately, Excel stores multiple redundant caches, massively increasing your file size.

Excel & Data Problems