Excel Performance Problems

Fix Excel 365 Out of Memory Errors and Workbook Crashes

Maira MehtabMaira Mehtab Nov 22, 2026 868 views

Question details

Identify why large Excel workbooks crash or run out of memory after a Microsoft 365 migration.

Fix Excel 365 Out of Memory Errors and Workbook Crashes
Product
Microsoft Excel for Microsoft 365
Device & OS
Windows 10 Enterprise version 1703, build 15063.1206, reported on affected computers
Scenario
Users refresh and save large workbooks containing Access connections, tables, controls, and extensive VBA code.
Observed behavior
Excel shows out-of-memory errors, crashes, displays a white screen, or locks up, particularly during refresh and save operations.
Before you start

Record the Excel version, build, and bitness from File > Account > About Excel, along with the Windows version. Check whether the issue occurs during a specific connection refresh or save operation and whether the data source or its location has changed.

Solution 1Recommended

Check Excel bitness and test the workbook in 64-bit Excel

Use this approach when a large workbook runs in 32-bit Excel and may be reaching its address-space limit.

A 32-bit Excel process has a limited address space even when the computer has plenty of RAM. The available limit depends on the Office build and Windows configuration; 64-bit Excel can address substantially more memory.

1
Check the installed version

In Excel, select File > Account > About Excel and record the version, build, and whether it says 32-bit or 64-bit.

2
Check compatibility

Ask your IT administrator to verify that required add-ins, VBA declarations, controls, and Access database drivers are compatible with 64-bit Office before changing the installation.

3
Test 64-bit Excel

On a suitable test computer with 64-bit Office installed, open the workbook, run Data > Refresh All, and save it. Compare the result with the 32-bit installation.

Check Excel bitness and test the workbook in 64-bit Excel
Plan the change with IT: Switching Office bitness may require removing the existing Office installation and resolving driver or add-in compatibility issues.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to try existing spreadsheets. It does not fix Microsoft Excel memory errors; test complex workbooks carefully before migrating.

Open and edit common Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for everyday workbook tasksTry a free, lightweight alternative to Microsoft OfficeReview large workbooks in another spreadsheet application as part of your evaluation
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel run out of memory when the computer has plenty of RAM?

A 32-bit Excel process has a limited address space regardless of installed RAM. Check File > Account > About Excel for its bitness and test the workbook in 64-bit Excel if its dependencies are compatible.

How can I tell which Office build is installed?

In Excel, open File > Account > About Excel to see the version, build, and whether the installation is 32-bit or 64-bit. Record these details for comparison across affected computers.

What should I check if Excel crashes during Refresh All?

Open Data > Queries & Connections, confirm that the Access data sources are reachable, and refresh connections individually to identify the operation associated with the crash.

Can turning off AutoSave help diagnose a crash?

It can help isolate whether AutoSave contributes to the issue. If the AutoSave toggle is available at the top of Excel, turn it off and repeat the refresh and save workflow.

Will WPS Office run all VBA code and Access connections in my workbook?

Compatibility with complex VBA, controls, and Access connections is not guaranteed. Open and test the workbook in WPS Office before relying on it for the same workflow.