Large Excel File Keeps Crashing? Practical Fixes to Try

Errors & fixes · Updated November 18, 2026

If a large Excel file keeps crashing, first make a copy of it, then open Excel in Safe Mode and try the copy; this helps protect the original and reveal whether an add-in or workbook feature is responsible. If the file still fails, reduce calculation and data load, check available memory, and use Excel’s repair or recovery options rather than repeatedly reopening the only copy.

Why a large workbook can crash

File size alone does not explain every crash. An Excel workbook can contain millions of formulas, extensive formatting, pivot caches, images, external links, or data connections that take far more memory and processing than its saved size suggests. A modest-looking file may also trigger lengthy recalculation whenever a cell changes. Conversely, a large workbook containing mostly static values may open reliably on the same computer.

Excel for Microsoft 365 on Windows supports up to 1,048,576 rows and 16,384 columns per worksheet, but those worksheet limits are not a promise that every workbook near them will run smoothly. Practical capacity depends on the amount and type of data, Excel’s 32-bit or 64-bit installation, available memory, other running applications, and workbook design. Excel can close, stop responding, or show an out-of-memory message when it cannot complete an operation with the resources available.

It also matters whether the failure is tied to one file or to Excel generally. If only one workbook crashes, investigate its contents, links, and integrity. If several unrelated files fail, look at add-ins, the Office installation, Windows updates, or system resources instead.

Protect the workbook before troubleshooting

Before trying repairs, make a duplicate in File Explorer and work on the copy. If the file is stored on a network drive, USB device, or cloud-synced folder, copy it to a local folder first. A dropped connection or sync conflict can interrupt saving, while repeated repair attempts can complicate recovery. Avoid overwriting the original until you have confirmed that the copy opens and contains the expected data.

For OneDrive or SharePoint files, check whether a prior version is available through Version History before making major changes. AutoSave can save supported cloud-hosted workbooks as changes are made, but it is not a substitute for a separate backup. Excel’s AutoRecover feature may preserve unsaved work after a crash, but it is also not a guaranteed backup of every change.

If Excel opens the file long enough to save it, use Save As to create another working copy. Keep a note of when the crash occurs: during opening, editing, recalculation, refreshing a query, or saving. That detail can point toward the cause and prevent unnecessary changes to the workbook.

Check whether Excel or the workbook is the problem

Start Excel without loading the usual add-ins by opening the Windows Run dialog with Windows key + R, typing excel /safe, and pressing Enter. Safe Mode starts Excel with several customizations and add-ins disabled. Open the copied workbook from inside Excel. If it behaves normally in Safe Mode, an add-in or customization is a likely factor; Safe Mode is a diagnostic step, not a permanent fix.

To review COM add-ins in normal Excel, go to File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. Clear a selected add-in, restart Excel, and test the workbook. Re-enable add-ins one at a time to identify a possible conflict. Some organizations manage add-ins centrally, so ask an administrator before changing a required business tool.

Test another workbook too. If a new blank workbook and several unrelated files crash, close other applications, restart Windows, and check whether Excel has updates under File > Account > Update Options > Update Now. If the issue continues across files, consider repairing Microsoft 365 from Windows Settings rather than making extensive changes to the workbook.

On a Mac, Windows Safe Mode and the Windows Run command do not apply. Start Excel without opening the problem file, then review Excel add-ins using the available Excel menu settings; the exact options can vary by build and add-in type. If the problem appears on Mac but not Windows, or the reverse, the difference can help isolate a platform-specific add-in, feature, or resource issue.

Reduce calculation and data-processing load

Formula-heavy workbooks often appear to crash because Excel is busy recalculating. Functions that recalculate frequently, formulas applied to entire columns, large array calculations, and chains of dependent formulas can all add work. For example, copying a formula that examines a whole column into thousands of rows can make Excel evaluate far more cells than the analysis requires.

For a diagnostic test, choose Formulas > Calculation Options > Manual. This stops automatic recalculation when values change, but it can leave results out of date. After making edits, use F9 on Windows to calculate open workbooks when ready; use Shift+F9 to calculate the active worksheet. Return Calculation Options to Automatic when the workbook is stable or when users need current results without manually recalculating. Manual calculation changes Excel’s calculation behavior and should not be mistaken for a repair.

Look for formulas that reference much larger ranges than necessary, duplicated calculations, or volatile functions such as NOW and TODAY when they are used extensively. Replace only what you understand: converting formulas to values removes their ability to update, so it is suitable for finalized results, not live calculations. If formulas depend on external workbooks, check whether those files are accessible and whether updating links is triggering a delay.

Large imports can also overwhelm a worksheet. If you use Power Query, consider whether the full result must be loaded to cells. For analysis, loading data to the Data Model or limiting the rows and columns in the query may be more efficient than placing every source record on a sheet. Confirm that reports, pivots, or formulas still get the data they need before changing the load destination.

Inspect formatting, pivots, and workbook features

Formatting can inflate workbook complexity even when it contains little meaningful data. A common example is formatting entire rows or columns, or repeatedly pasting from other files and leaving thousands of distinct cell styles. Use Ctrl+End on Windows to see the last cell Excel considers used. If it is far beyond the actual data, inspect the extra rows or columns before removing anything. On Mac, the equivalent shortcut and key combinations can vary by keyboard; use the Name Box to navigate to the last used area if needed.

Do not delete rows or clear formats blindly. First make a copy, then select only clearly unused rows or columns beyond the real data, remove them, and save, close, and reopen the copy. If the workbook contains carefully designed templates, conditional formatting, or hidden data, indiscriminate cleanup can damage them. Review conditional formatting rules under Home > Conditional Formatting > Manage Rules, especially if rules cover far more cells than intended.

PivotTables, charts, embedded pictures, and copied objects can add memory use. PivotTables may retain a cache of source data, while a workbook can also contain hidden sheets or objects that are not obvious during normal use. Remove or rebuild a feature only after confirming it is unnecessary. For a workbook shared with colleagues, check whether a chart, macro, or pivot depends on the feature before deleting it.

Check memory, Excel bitness, and file format

On Windows, open Task Manager with Ctrl+Shift+Esc and check whether memory use is already high while Excel is running. Close applications you do not need, but do not assume adding RAM alone will fix inefficient formulas or a damaged file. A 32-bit Excel installation has a more constrained address space than 64-bit Excel, which can matter for very large workbooks. The 64-bit edition can use more memory when the computer has it available, but it cannot remove worksheet limits or guarantee that a complex workbook will run without problems.

To check the Excel edition, go to File > Account > About Excel. The information identifies whether Excel is 32-bit or 64-bit. Moving to 64-bit Office may affect compatibility with older 32-bit add-ins, so check business software requirements before changing installations. Mac Excel does not use the Windows 32-bit versus 64-bit installation choice in the same way.

Saving a copy as Excel Binary Workbook (*.xlsb) can reduce file size or make some workbooks open and save more efficiently, although results vary. Use File > Save As and select the binary workbook type. XLSB supports many Excel features and macros, but confirm that the people and systems receiving the file can use it. CSV is not a general replacement: it stores plain tabular text for one sheet and does not preserve formulas, formatting, charts, multiple sheets, or macros. Keep the original XLSX or XLSM when those features matter.

Repair or recover a workbook that will not open

If the workbook still fails, use Excel’s built-in repair route on a copy. In Excel, select File > Open > Browse, select the file, click the arrow beside the Open button, and choose Open and Repair. Try Repair first. If that does not work, Excel may offer Extract Data, which can recover values and formulas while sacrificing some workbook features. Compare the result carefully with a backup or known source before relying on it.

If Excel crashes before you can save, reopen Excel and look for the Document Recovery pane. If it does not appear, check File > Info for Manage Workbook options, which may include recovering unsaved workbooks depending on the situation. You can also check File > Options > Save for the AutoRecover file location. Recovery availability depends on whether Excel had time to create recovery data, so do not treat it as certain.

For a workbook that opens but fails during saving, use Save As to a local location with a new filename and a supported workbook format. If saving still crashes, make a fresh workbook and move content across in manageable pieces, testing after each batch. Copying individual sheets can transfer the problem along with them, so if the crash returns after one sheet or object is added, investigate that content rather than continuing to copy everything.

When to choose a different approach

Some files have outgrown the worksheet model they were built for. If a workbook repeatedly needs millions of source records, extensive joins, or refreshes that take a long time, store and transform the data in a database or another suitable data platform, then bring summarized results into Excel for analysis. Excel remains useful for reporting and interactive analysis, but it is not always the best place to store every raw transaction indefinitely.

For a one-time analysis, split the work into smaller files or summarize the source before importing it. For recurring work, review whether Power Query, the Data Model, or a database-backed report can reduce duplicated data and formula recalculation. Choose based on how the workbook is used, who must maintain it, and whether the source data needs to remain traceable. A smaller file is not automatically a better file if it loses required detail or reproducibility.

Frequently Asked Questions

Why does Excel crash when I open a large file?
Excel may be loading a large amount of data, recalculating formulas, updating external links, or encountering a damaged workbook feature. Try a local copy, Safe Mode, and a test with another workbook to separate file-specific problems from Excel-wide ones.

Will upgrading to 64-bit Excel stop crashes?
It can help when a 32-bit installation runs into memory constraints and the computer has sufficient memory, but it is not a guaranteed fix. Workbook design, add-ins, corruption, and available system resources can still cause crashes.

Does saving as XLSB make Excel faster?
It may reduce file size or improve opening and saving for some workbooks, but the improvement is not universal. Keep a separate original, test important features, and confirm that recipients can use the binary format.

Can I recover a file after Excel crashes?
Possibly. Check the Document Recovery pane, File > Info, and the AutoRecover location configured in Excel. Recovery depends on what Excel managed to save, so compare recovered content against a backup whenever possible.

Is it safe to delete unused rows to reduce file size?
Only after checking that they are genuinely outside the data and are not used by formulas, formatting, macros, or templates. Work on a duplicate, remove clearly unnecessary content, then save, close, and reopen to verify the result.

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.