Excel Data File Too Large? Fix Size and Find the Cause

Errors & fixes · Updated November 19, 2026

If an Excel data file is too large, first work out whether the problem is opening, saving, sharing, or fitting the data on a worksheet; then remove unnecessary workbook content or move the data to a more suitable format or tool. An Excel worksheet is limited to 1,048,576 rows and 16,384 columns, but a workbook can become unwieldy well before it reaches those limits.

Why an Excel workbook gets large

The amount of visible data is only one part of a workbook’s size. Excel also stores formatting, formulas, charts, images, pivot tables, cached results, connections, and other workbook structures. A sheet with a few thousand rows can therefore make a surprisingly large file if every cell has elaborate formatting or the workbook contains many embedded objects.

File size on disk and the amount of memory needed while Excel is open are related, but they are not the same thing. The .xlsx format compresses workbook contents, so a file that looks modest in File Explorer may take much more memory to calculate, display, or refresh. A workbook with volatile formulas, complex calculations, or many styles can feel slow even if its saved file is not enormous.

Also distinguish a large workbook from a large source file. A CSV containing millions of records may be large, but it does not have Excel workbook features such as multiple sheets, formatting, or charts. Opening that CSV directly in a worksheet can fail to show every record because of the worksheet row limit.

Know the worksheet and format limits

In current Excel for Microsoft 365 on Windows, a worksheet has a maximum of 1,048,576 rows and 16,384 columns, ending at column XFD. A single cell can contain at most 32,767 characters. These are worksheet limits, not a promise that a workbook of that size will perform well on every computer.

Older .xls workbooks have much lower worksheet limits: 65,536 rows and 256 columns. If an old-format workbook is opened in a newer Excel version, it can still operate in compatibility mode with those restrictions. Saving a copy as .xlsx may remove those older sheet limits, but it does not make a very large or complex workbook automatically fast.

There is no single practical file-size threshold that guarantees every workbook will open successfully. Available memory, whether Excel is 32-bit or 64-bit, workbook complexity, and the device or service handling the file all matter. A workbook can also exceed a mail attachment or cloud-upload limit even though Excel itself can open it.

Find what is taking up space

Start with a copy of the workbook, especially if it contains important formulas or business records. Check the file’s size in File Explorer and compare it with a saved copy after each cleanup step. If a workbook is slow or reports that it cannot save, note whether the issue began after adding data, copying sheets, inserting images, or applying formatting to large ranges.

  • Use Ctrl+End on Windows to move to the last cell Excel considers used on the active sheet. If it lands far below or to the right of your real data, the sheet may contain unwanted formatting or other content in that area.
  • Look for oversized images, repeated copies of sheets, hidden sheets, and unnecessary charts or objects. Check formulas for references to entire columns when a bounded range would do.
  • Review conditional formatting rules and cell styles if the workbook grew after formatting was applied. Copying content from many different workbooks can bring in a large collection of styles.
  • Check whether PivotTables, queries, or external data connections retain data that you do not need. Do not remove a connection or cache until you know whether users rely on its refresh behavior.

Ctrl+End reports Excel’s used area, not a definitive diagnosis of file size. A distant last cell is a clue to investigate, rather than proof that the workbook is damaged. On Mac, keyboard behavior can depend on the keyboard and Excel version; use the equivalent End navigation key where available, or inspect the sheet’s scroll bars and last populated cells.

Remove excess formatting and unused content

If Ctrl+End lands far beyond the real data, select the surplus rows or columns and remove them. For example, if data ends at row 8,000, select row 8,001 through the bottom of the sheet, then use Home > Delete > Delete Sheet Rows. Repeat for unused columns to the right of the actual data. Save, close, and reopen the workbook so Excel can recalculate the used area.

Deleting rows or columns can affect formulas, named ranges, charts, and references, so do this only after reviewing the copy and checking the result. If you only want to remove formatting from a range while retaining its values, select the range and choose Home > Clear > Clear Formats. Clear All removes more than formatting, including cell contents, so use it only when that is intended.

For excessive conditional formatting, select the affected cells and review Home > Conditional Formatting > Manage Rules. Remove duplicate or obsolete rules rather than deleting rules indiscriminately; some rules may be essential to interpreting the sheet. For images, resize them or use a lower-resolution source when fine detail is unnecessary. Save the cleaned file under a new name and compare both its size and its appearance.

Reduce the amount of data Excel must handle

Keep only the columns and records needed for the task at hand. If a workbook contains years of transaction history but a report only needs the current year, filter the source before loading it. If users need a summary rather than every detail row, a PivotTable or a grouped report may communicate the result with much less visible data.

For repeatable imports, use Power Query instead of pasting large source files into sheets. In Excel for Microsoft 365 on Windows, start with Data > Get Data and choose the appropriate source, such as From File > From Workbook. In the Power Query Editor, remove unnecessary columns, filter rows, and set data types before loading. Loading a query as a connection or to the Data Model can avoid placing every record on a worksheet, though it does not mean the data has disappeared: the model or connection still uses resources and may increase the workbook’s size.

Excel tables and formulas are useful for analysis, but avoid filling entire columns with formulas when only a limited number of rows contain records. Replace repeated intermediate calculations with a well-designed summary where appropriate, and remove obsolete sheets or formulas only after confirming that no reports depend on them. Reducing data should preserve the information needed for audits, updates, and future analysis.

Choose a file format that fits the job

The default .xlsx format is a good general choice for workbooks without VBA macros. The .xlsb binary workbook format can make some workbooks smaller or quicker to open and save, but the result depends on the workbook. Try it on a copy using File > Save As > Browse, then select Excel Binary Workbook (*.xlsb) in Save as type. Verify the saved workbook and make sure the people and systems receiving it support .xlsb.

If the workbook contains VBA macros, preserve them in a macro-enabled format such as .xlsm or .xlsb. Saving a macro-enabled workbook as .xlsx removes its VBA project, so do not change formats without checking. A .csv file can be useful for transferring plain tabular data, but it stores only one sheet and does not retain formulas as formulas, formatting, charts, or workbook features. It is not a smaller substitute when those features matter.

When sharing, a compressed ZIP copy may reduce transfer size in some situations, but it does not reduce the workbook’s working size after it is extracted. Do not rename an Excel file’s extension to make it appear to be another format. Use Save As to create a valid file in the format you actually need.

When a worksheet is the wrong place for the data

If the source contains more than 1,048,576 records, a single worksheet cannot hold them all. Splitting the records across sheets may be a temporary workaround, but it can make filtering, deduplication, and reporting harder. For recurring work with large datasets, consider a database or another data platform designed to store and query records, then bring only the required results into Excel.

Power Query and the Excel Data Model can help analyze data that is too large or awkward to load directly into a worksheet, subject to available memory and the limits of the particular Excel environment. Excel for the web, desktop Excel, and other spreadsheet programs do not have identical capabilities or performance. If collaborators use different versions or software, test the workflow with the largest expected file before relying on it.

Keep the raw source in a controlled location and use Excel for analysis, summaries, and presentation when that is the more reliable arrangement. This separates the durable record from a report that can be rebuilt, and reduces the risk that someone accidentally edits or deletes source data while working in a spreadsheet.

Frequently Asked Questions

What is the maximum size of an Excel file?
There is no universal practical file-size number that applies to every workbook and computer. Worksheet row, column, and cell-character limits are defined, but the workbook’s usable size also depends on memory, Excel architecture, content, and any upload or sharing limits involved.

Why is my Excel file large when it has only a few rows?
Unused formatted cells, copied styles, embedded images, hidden content, PivotTable data, or excessive conditional formatting can add size even when visible data is limited. Check the used range with Ctrl+End and inspect objects and formatting on a copy.

Will saving as XLSB make my workbook smaller?
It may, but the amount varies and some files may not shrink meaningfully. Save a separate .xlsb copy, compare its size and behavior, and confirm that recipients can use the format. Preserve a macro-enabled format if the workbook uses VBA.

Can Excel open more than one million rows?
A worksheet cannot display more than 1,048,576 rows. You can work with larger sources through tools such as Power Query and the Data Model in supported desktop Excel workflows, but the exact approach depends on the data and available system resources.

Does compressing an Excel file fix the problem?
Compression can help with transferring or storing a file, but it does not remove workbook content or make calculations lighter once the file is open. To reduce working demands, remove unnecessary content, narrow the data being loaded, or move the underlying dataset to a suitable data platform.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.