Not Enough Memory
Microsoft Excel
Severity: ModerateWhat it means
Not enough memory in Excel means the application has run out of available RAM.
This happens with very large spreadsheets, too many formulas, or too many other programs running.
Close other applications and simplify your spreadsheet.
Affected Models
- Microsoft Excel 365
- Microsoft Excel 2021
- Microsoft Excel 2019
- Windows
- macOS
Common Causes
- Spreadsheet has too many rows, columns, or complex formulas
- Too many other applications consuming RAM
- 32-bit version of Excel (limited to 2GB RAM)
- Excessive conditional formatting rules
- Large pivot tables or data connections
How to Fix It
-
Close other applications to free up RAM.
Check Task Manager (Ctrl+Shift+Esc) to see what is using memory.
Close browsers, other Office apps, and anything you do not need. -
Switch to 64-bit Excel if you are on 32-bit.
32-bit Excel can only use 2GB of RAM, even on a 64-bit system.
Check: File > Account > About Excel.
If it says 32-bit, reinstall as 64-bit. -
Reduce spreadsheet complexity.
Remove unnecessary conditional formatting rules.
Convert volatile formulas (INDIRECT, OFFSET) to static values where possible.
Delete unused worksheets. -
Break large spreadsheets into multiple smaller files.
Instead of one massive file, split data across multiple workbooks.
Use links between files if they need to reference each other.
Frequently Asked Questions
How much RAM does Excel need?
For normal spreadsheets: 4-8GB is sufficient.
For large datasets with pivot tables: 16GB+ recommended.
64-bit Excel can use all available system RAM.
Can I check how much memory Excel is using?
Yes.
Open Task Manager (Ctrl+Shift+Esc), find Excel in the list, and check the Memory column.
If it is near 2GB, you are likely on 32-bit Excel hitting its limit.