Excel File Too Large? How to Find and Fix It in Excel

Errors & fixes · Updated November 20, 2026

If your Excel file is too large to open, save, email, or share, first work out whether the problem is its size on disk, Excel’s worksheet limits, or the memory available to your computer. Then make a copy and remove unnecessary data or formatting, reduce oversized pictures, and choose a suitable file format; the safest fix depends on what is actually making the workbook large.

What “too large” can mean

A workbook’s size in File Explorer is not the same thing as the amount of memory Excel needs while it is open. An .xlsx file is a compressed package of workbook data, so its on-disk size can be relatively small even when its worksheets, formulas, and objects take much more working memory to process. A computer with limited available memory may therefore struggle with a workbook that does not look enormous in File Explorer.

There are also different kinds of limits. A worksheet in current Microsoft Excel supports up to 1,048,576 rows and 16,384 columns, but that does not mean a workbook of that size will run comfortably. Excel also has a 32,767-character limit for the contents of a single cell. Older .xls workbooks have lower worksheet limits: 65,536 rows and 256 columns. A file can be inconvenient or slow well before it reaches any of these limits.

Be specific about the symptom. A workbook that is slow to calculate needs a different remedy from one that cannot be attached to an email or one that fails to open. A sharing service may impose its own upload or attachment limit, which is separate from Excel’s worksheet limits.

Find out what is taking up space

In Windows File Explorer, right-click the workbook and choose Properties to check its size on disk. If Excel can open it, note whether the problem is a long delay, an error message, a failed save, or simply a large attachment. That information helps distinguish a bloated workbook from a computer or service limit.

Look through the workbook for common sources of unnecessary weight. A few large pictures, many formatted but empty cells, extensive conditional formatting, duplicate copies of raw data, or embedded files can matter more than the visible table suggests. Hidden worksheets and rows count too. A workbook with formulas filled far below the actual records may contain far more active cells than you expect.

  • Check how many worksheets are present, including hidden ones.
  • Look for pictures, charts, shapes, embedded documents, and other objects.
  • Inspect whether formatting or formulas extend far beyond the real data.
  • Consider whether the workbook contains PivotTable caches or imported data that is also stored elsewhere.

Make a safe copy before changing anything

Use File > Save As to create a separate working copy before deleting sheets, rows, columns, connections, or objects. Keep the original until you have checked that the smaller file still contains the data and results you need. If the workbook is shared or contains business-critical information, make sure you have permission to change its contents and preserve any required historical records.

Do not assume that every large item is disposable. A hidden sheet may feed a report, a picture may be evidence or a product image, and a query may refresh the numbers used by a dashboard. Check the purpose of an item before removing it. If you are unsure, save a copy and test the change there.

Remove unused cells and formatting

Formatting applied to thousands of empty rows or columns can make Excel treat a much larger area as used. On Windows, press Ctrl+End to move to the last cell Excel considers used on the active worksheet. If that cell is far beyond your real data, inspect the intervening area before making changes. On a Mac, Control+End usually serves the same purpose; on some keyboards you may need Fn+Control+Right.

If the worksheet’s actual data ends at row 500 but Excel’s used area extends to row 500,000, first confirm that the later rows do not contain meaningful information, formulas, or references. In a copy, select the unused rows by their row headings and use Home > Delete > Delete Sheet Rows. You can do the equivalent for unused columns with Home > Delete > Delete Sheet Columns. If the issue is only unwanted formatting, select the affected empty cells and choose Home > Clear > Clear Formats instead.

Save the workbook, close it, and reopen it before checking Ctrl+End again. Excel may not update its recorded used area until the workbook is saved and reopened. Deleting rows or columns can affect formulas and references, so verify important calculations and charts afterward. Do not delete rows merely because they look blank; they may be part of a template or a future data-entry area.

Reduce formula and calculation overhead

Formulas do not all impose the same workload. A large number of formulas, formulas that refer to very large ranges, or complex calculations repeated across many rows can make a workbook slow and memory-intensive. Some functions recalculate frequently, and formulas that depend on external workbooks can also create delays when those sources are unavailable.

Look for formulas copied much farther down than the records require, duplicated calculations that could be shared, and references to entire columns where a smaller range would do. Be careful: changing a formula range can change the result if new records are expected to be added later. If a report only needs a frozen snapshot, you may be able to replace selected formulas with their current values using Copy and Paste Special > Values, but that removes the formulas and future recalculation. Keep a formula-based copy if you may need to update the results later.

Calculation settings are not a file-size cure by themselves. Switching calculation to manual may reduce pauses while editing, but Excel will not automatically recalculate every formula after each change. If you use manual calculation, recalculate when needed and make the setting clear to anyone who receives the workbook.

Compress pictures and remove surplus objects

High-resolution photos can take up much more space than the cells around them. Select a picture and look for Picture Format > Compress Pictures. The available controls can vary with the selected image and Office version; choose an appropriate resolution for how the workbook will be viewed, and avoid discarding cropped areas if you might need to restore them. Check the result at normal viewing size because aggressive compression can make images visibly worse.

Also inspect charts, shapes, screenshots, and embedded files. An embedded document may contain a complete second file inside the workbook. If readers only need to open that document separately, a link to a managed shared location may be more efficient, provided the recipients have access. Removing an object can affect a report or instructions, so check the workbook’s intended use before doing so.

Choose a file format that fits the job

For most workbooks, .xlsx is the standard format and a sensible choice. Saving a legacy .xls file as .xlsx may reduce size and provides the newer worksheet limits, but check compatibility with anyone who still uses older software. Use .xlsm when the workbook needs VBA macros; saving a macro-enabled workbook as .xlsx removes its macros.

The .xlsb binary workbook format can be smaller or faster to open and save for some large workbooks, but the result depends on the workbook. It is not a guarantee of a dramatic reduction, and some systems or workflows may not accept it as readily as .xlsx. Try Save As > Excel Binary Workbook (*.xlsb) on a copy, then confirm that formulas, macros, connections, and recipient workflows still work.

CSV is not a smaller substitute for a complete Excel workbook. A CSV file stores plain text data for one worksheet, not workbook formatting, charts, multiple sheets, or Excel formulas as working formulas. Use it only when you need to exchange a flat table of data and have confirmed what values will be exported.

Review imported data, PivotTables, and connections

Workbooks that import or summarize large datasets may store both the visible report and supporting data. A PivotTable can retain a cache of its source data, and a data model or query may keep data inside the workbook. Deleting the visible source sheet does not necessarily remove every stored copy, while removing a cache or connection may stop a report from refreshing.

Check Data > Queries & Connections to review queries and connections in the workbook. For PivotTables, inspect the PivotTable options and understand whether source data is saved with the file before changing the setting. The exact controls can depend on the kind of PivotTable and data source. If the workbook needs refreshable reports, keep the necessary connection or source data; if it is only a static report, a separate trimmed copy may be appropriate.

For recurring analysis of data that does not need to sit visibly in worksheet cells, consider loading and transforming it with Power Query or using Excel’s Data Model where appropriate. These tools do not remove all memory or file-size costs, and the Data Model may itself store substantial data, but they can be more manageable than thousands of copied formulas or several duplicate raw-data sheets.

When sharing is the real problem

If the workbook opens and works but cannot be emailed, the limit may belong to the email provider or organization rather than Excel. Avoid repeatedly compressing or splitting a workbook if that creates confusion about which copy is current. A safer option is often to store it in OneDrive or SharePoint and share a link with the right access permissions. Upload limits and sharing policies vary, so check the service or workplace rules.

Before sharing, remove confidential information only if you are authorized to do so, and check hidden sheets, comments, and document properties when relevant. Excel’s File > Info area includes document inspection options in supported versions; review any warnings carefully. A smaller workbook is not automatically a safer workbook, and a link should be shared only with the intended audience.

Frequently Asked Questions

What is the maximum size of an Excel file?
There is no single practical file-size figure that guarantees every workbook will open on every computer. Excel’s worksheet row and column limits are fixed, but usable workbook size depends on its contents, Excel version, available memory, and system resources. The receiving email or storage service can impose a separate limit.

Why is my Excel file large when it has little data?
Formatting on unused cells, leftover used ranges, pictures, embedded files, hidden sheets, PivotTable caches, or stored imported data can add size even when the visible table is small. Check the used area with Ctrl+End, inspect objects and hidden sheets, and try changes only on a copy.

Will saving as XLSB make my workbook smaller?
It may, but the result varies by workbook. Save a copy as .xlsb, compare its size and performance, and confirm that the people and systems using it support the format. Retain .xlsm instead if VBA macros must be preserved in a macro-enabled workbook.

Can I delete blank rows to reduce file size?
Only if they are genuinely unused. Deleting rows or columns can change formulas, references, charts, or template layouts. First save a copy, inspect the area beyond the real data, and verify the workbook after saving and reopening it.

Does compressing an Excel file as a ZIP solve the problem?
It can help with transferring a file, but it usually does not make the workbook itself easier for Excel to calculate or edit. Modern .xlsx files are already compressed packages, so ZIP compression may produce only a modest change. It also means the recipient must extract the workbook before opening it.

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.