Excel Workbook Size Limit: Memory, File Size, and Limits

For Excel for Microsoft 365 on Windows, there is no single fixed maximum file size for a modern .xlsx workbook: practical size is limited by available memory and system resources. Excel does have firm limits for each worksheet, including 1,048,576 rows and 16,384 columns, and 32-bit Excel can run into memory constraints much sooner than 64-bit Excel.

What “workbook size limit” means

A workbook’s size can refer to three different things: the size of its saved file, the amount of data it contains, or the resources it needs while open. Those measures do not match. An .xlsx file is a compressed package, so its size on disk can be much smaller than the memory Excel needs to calculate and display it. Conversely, a workbook containing many pictures or embedded objects can occupy substantial disk space without filling the worksheet grid.

That distinction explains why two workbooks with the same file size can behave very differently. A workbook with many formulas, formatting rules, and pivot caches may need considerably more memory than a workbook made mostly of plain text. The useful answer is therefore not a universal number of megabytes. It is a combination of Excel’s hard structural limits, the file format, the device’s available resources, and any limits imposed by the service where the file is stored.

Hard limits on a worksheet

In current desktop Excel, each worksheet has a grid of 1,048,576 rows by 16,384 columns. The final column is XFD. These are per-sheet limits, not a cap on the total number of cells in an entire workbook. A workbook can have multiple sheets, but the practical number depends on memory and resources rather than a single fixed sheet count in modern Excel.

Other worksheet limits can matter before the grid is full. A cell can contain up to 32,767 characters, and a formula can be up to 8,192 characters long. Excel also limits numeric precision to 15 significant digits. For example, a 16-digit identifier should generally be stored as text if every digit must be retained; entering it as a number can cause the last digit or digits to change. These constraints affect the content of a workbook, not the maximum size of its saved file.

Older .xls workbooks have much smaller worksheet dimensions: 65,536 rows by 256 columns, ending at IV. If a file is opened in compatibility mode or saved in that older format, these restrictions can become relevant. The familiar .xlsx format supports the larger modern grid.

How memory affects workbook size

Excel must load workbook data and related structures into memory to work with them. Formulas, calculation dependencies, styles, images, charts, pivot caches, and add-ins all contribute to resource use. A workbook may open successfully but still become slow, fail to recalculate, or display an out-of-memory message when the computer cannot provide enough resources for the operation.

Excel’s architecture matters. The 64-bit edition can address far more memory than the 32-bit edition, although it is still limited by the computer’s installed memory, operating system, and other running applications. In 32-bit Excel, the address space is restricted; on 64-bit Windows, supported 32-bit Excel versions can access a larger address space than on 32-bit Windows, but that space is shared with Excel itself, add-ins, and open workbooks. A large file that fails in 32-bit Excel may work in 64-bit Excel, but changing editions does not remove worksheet limits or guarantee that every workbook will run quickly.

If a workbook is close to the computer’s practical capacity, performance can deteriorate before Excel reaches any formal maximum. Recalculation, sorting, filtering, refreshing a data connection, or copying a large range can require extra temporary memory. Keeping other memory-intensive applications open can make the same workbook harder to use.

File formats and what they change

The usual modern workbook format, .xlsx, is based on an XML package compressed for storage. Its on-disk size is not a direct measure of the memory required to use it. The older .xls format has a 2 GB workbook file limit as well as its smaller worksheet grid, so it is unsuitable for many large modern datasets.

The .xlsb format stores workbook content in a binary format and can produce a smaller file or improve opening and saving performance for some workbooks. It does not expand the worksheet grid or make memory unlimited. It can also be less convenient for systems that expect .xlsx, so check compatibility with colleagues, reporting tools, and automated processes before changing formats.

Macro-enabled .xlsm files can contain VBA code, but the macro-enabled extension is not a way around Excel’s grid or memory constraints. Choose a format based on the workbook’s contents and the software that must open it, not just on which extension produces the smallest file.

What makes a workbook unexpectedly large

Visible data is only part of a workbook. Formatting applied far beyond the actual dataset can make Excel treat a much larger area as used. For instance, formatting entire columns or pasting styles into thousands of empty rows may create an oversized used range. Excessive unique cell formats can also increase file size and make Excel slower.

Other common contributors include:

Pictures, screenshots, and other inserted objects, especially high-resolution images.
Many formulas, particularly formulas repeated over large ranges or volatile formulas that recalculate often.
Pivot tables with saved source data, multiple pivot caches, and large data models.
Conditional formatting rules applied to unnecessarily large ranges.
Hidden sheets, old imported data, and unused named ranges or connections that remain in the file.
Embedded files, such as documents or other workbooks, which can add substantial content.

A large file is not automatically a bad workbook. A detailed model may need its formulas and history. The aim is to identify unnecessary content rather than remove useful data simply to reduce a number shown in File Explorer.

How to check and diagnose a large workbook

Start by checking the saved file size in File Explorer. In Excel, use File > Info to review workbook information and look for available inspection tools. Then compare the file’s size with its behavior: does it take a long time to open, recalculate, save, or refresh? Slow performance can point to a calculation or memory issue even when the file is not exceptionally large.

To investigate excess formatting, press Ctrl+End on Windows to move to the last cell Excel considers used on the active sheet. If that cell is far beyond the actual data, the used range may include stray formatting or past content. This shortcut has no direct Mac equivalent with the same key combination; on Mac, use the keyboard navigation shortcuts available for the installed Excel version, or navigate to the last used cell through the interface. Before removing rows or columns, confirm they do not contain data, formulas, or objects you need.

For a careful check, inspect sheets one at a time, review conditional formatting and named ranges, and look for large objects or unused pivot tables. Save a separate copy before cleanup. Close and reopen the cleaned copy to see whether its file size and responsiveness improve; Excel may not immediately rewrite every piece of workbook structure until the file is saved.

Ways to reduce size without losing important data

Make a backup before deleting content or changing formats. Then use the least disruptive cleanup that addresses the cause:

Remove unused rows, columns, and sheets only after checking that they contain no needed content. Clear unnecessary formatting in empty areas rather than applying formatting across whole sheets.
Reduce image dimensions or use compressed images when the workbook contains large pictures. Avoid embedding files that could instead be stored separately and linked where appropriate.
Limit conditional formatting to the actual data range and remove duplicate or obsolete rules.
Review formulas and calculation settings. Avoid keeping millions of unnecessary formulas just because the worksheet grid permits them.
For very large datasets, consider whether all records need to be displayed as worksheet cells. Power Query and the Excel Data Model can support analysis workflows that do not require placing every source record directly on a sheet, though they still use memory and have their own practical limits.
Test .xlsb if a smaller or faster-to-open file would help and the people or systems using it support that format.

Do not delete pivot caches, connections, or historical rows until you understand how reports depend on them. A reduction in file size is not worth breaking a refresh process or removing information needed for an audit.

Sharing, cloud storage, and Excel for the web

A workbook that works on a desktop may encounter a different limit when uploaded, emailed, synchronized, or opened in a browser. The service handling the file can impose its own upload, storage, or browser-editing restrictions. Those are separate from Excel’s worksheet limits and can vary by service, account, or organization settings. Check the current limits for the specific OneDrive, SharePoint, email, or other platform involved rather than assuming that Excel’s desktop capacity applies there.

Excel for the web also runs in a browser environment and does not have the same resources or feature coverage as desktop Excel in every situation. A large or complex workbook may open differently or be less responsive online. If a workbook is important to a workflow, confirm that it can be opened and edited in the intended environment before relying on browser access. Sharing a link rather than attaching repeated copies can help avoid duplicated files, but it does not reduce the workbook’s actual contents.

Frequently Asked Questions

How many rows can an Excel workbook have?
Each worksheet in modern Excel supports up to 1,048,576 rows and 16,384 columns. A workbook can contain multiple sheets, but its practical overall capacity depends on available memory and system resources.

Is there a 2 GB limit for every Excel file?
No. The 2 GB file limit is associated with the older .xls format. Modern .xlsx workbooks do not have one universal desktop file-size ceiling; memory, system resources, format details, and the storage or sharing service can impose practical limits.

Will 64-bit Excel open a workbook that 32-bit Excel cannot?
It may, because 64-bit Excel can address substantially more memory. It is not a guarantee: the workbook can still exceed practical system resources, run slowly, or encounter a separate limit such as the worksheet grid or a cloud service’s file restriction.

Does saving as .xlsb remove Excel’s limits?
No. .xlsb may reduce file size or improve performance for some workbooks, but it does not increase the number of rows or columns on a worksheet or eliminate memory constraints.

Why is my Excel file so large when it has little visible data?
Unused formatting, a used range extending far past the data, embedded images or objects, pivot caches, hidden content, and large conditional-formatting ranges can all add size. Inspect those areas before deleting anything.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.