Fix Excel Cannot Open a 2 GB Workbook on a 64-Bit System
Question details
The user is unable to open a 2 GB Excel workbook in 64-bit Excel despite 16 GB of RAM and wants options before contacting the file creator.
- Product
- Microsoft Excel (64-bit)
- Device & OS
- not provided
- Scenario
- The workbook contains formulas, pivot tables, diagrams, datasets, and external references and was provided as part of a project.
- Observed behavior
- Excel consumes available memory and fails to open the workbook, even with 16 GB of RAM and in 64-bit Excel.
Before troubleshooting, confirm with the file creator whether the workbook opens on their machine and request a copy that has been split or saved in a smaller format if available.
Verify the Workbook Opens for the File Creator and Obtain a Clean Copy
Use this first when the workbook was shared by a colleague or client; it helps rule out file corruption or incomplete transfer before you change any Excel settings.
A 2 GB workbook may be corrupted or may exceed Excel's practical memory limits even on 64-bit. The file creator often knows whether the workbook is valid and may be able to provide a smaller or split version.
Contact the person who provided the file and ask them to open the same 2 GB workbook on their machine.
If it opens for them, ask the file creator to save a copy as an .xlsx or .xlsb file and remove unnecessary sheets, diagrams, or external links.
Download or copy the new file to your computer and confirm the file size is the same as the source before opening it in Excel.
Reduce or Split the Large Excel Workbook
Use this when the workbook is valid but too large; reducing formulas, objects, and external links or splitting sheets can lower memory usage and make the file open reliably.
Open Excel in Safe Mode to Rule Out Add-ins
Use this as a quick diagnostic when you want to confirm that an add-in is not blocking the large workbook, although it may not solve a memory-related failure.
Use WPS Office as a Free Microsoft Office Alternative for Daily Spreadsheet Work
For everyday workbooks, WPS Office is a free, lightweight Office alternative that opens and saves Microsoft Excel .xlsx files with a familiar ribbon interface and strong format compatibility, helping you move away from Excel memory-limit roadblocks in normal daily tasks.
- 1. Download WPS Office: Go to the official WPS Office website and click the free download button for Windows.
- 2. Install and launch WPS Spreadsheets: Open the downloaded installer, complete the installation, and start WPS Spreadsheets from the WPS Office home screen.
- 3. Open your existing .xlsx files: Click Menu > Open, choose a normal .xlsx workbook, and continue editing with the familiar spreadsheet interface.

Frequently Asked Questions
Why does Excel fail to open a 2 GB workbook even on a 64-bit system?
64-bit Excel can address more memory than 32-bit, but very large workbooks with formulas, pivot tables, diagrams, and external references can still exhaust available RAM or hit Excel's practical limits, causing the file to fail to open.
Does starting Excel in Safe Mode fix a memory-related workbook problem?
Safe Mode only disables add-ins and may help identify add-in conflicts. It does not increase available memory, so a workbook that exceeds Excel's practical memory limit may still not open.
How can I reduce an Excel workbook that is too large to open?
If you can open the file on another machine, remove external links via Data > Edit Links, delete unused names in Formulas > Name Manager, delete objects and unused sheets, and split the workbook into smaller files.
Can WPS Office open a 2 GB Excel workbook?
WPS Spreadsheets supports .xlsx files, but extremely large files are still limited by your computer's available memory. For reliable use, reduce the workbook or split it into smaller files before opening it in any spreadsheet application.
What should I do if the file creator cannot open the workbook either?
The file may be corrupt. Try to obtain a backup or exported copy, recover data from source systems or database exports, or use Excel's Open and Repair option if the file is only slightly damaged.




