Fix Excel 365 Out of Memory Errors and Workbook Crashes
Question details
Identify why large Excel workbooks crash or run out of memory after a Microsoft 365 migration.

- 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.
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.
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.
In Excel, select File > Account > About Excel and record the version, build, and whether it says 32-bit or 64-bit.
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.
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.

Update Office and Windows, then test AutoSave
Use this method to check whether an Office build issue or AutoSave contributes to the crashes.
Isolate data connections, VBA, and workbook complexity
Use targeted tests when crashes occur during refresh or save, even after checking bitness and updates.
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.

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.




