Home / Error Lookup / EXCEL-OUT-OF-RESOURCES

EXCEL-OUT-OF-RESOURCES

Excel Excel Ran Out of Resources Applies to: Windows 7, Windows 10, Windows 11

What it means

Excel hit a memory or resource ceiling, often tied to running 32-bit Office on a very large file rather than actual RAM shortage.

Also seen as: not enough memory to complete this action

Quick fix steps

  1. Close other open workbooks and heavy background apps.
  2. Check File > Account > About Excel to see if you're on 32-bit Office, which has a much lower memory ceiling regardless of your PC's RAM.
  3. Trim the used range: select past your real data with Ctrl+Shift+End and delete the excess rows/columns, then save.
For the full step-by-step walkthrough, see Excel Says It's Out of Resources or Memory.

Frequently Asked Questions

Does this mean I need a more powerful computer?
Not always — closing other open programs and browser tabs first frees up resources and often resolves this without needing new hardware, especially if the spreadsheet itself isn't exceptionally large.
Is 32-bit vs 64-bit Excel relevant here?
Yes — 32-bit Excel has a much lower memory ceiling than the 64-bit version, so switching to 64-bit Office (if you're not already using it) can meaningfully help with large, resource-intensive spreadsheets.

Other error codes

#REF! — #REF! Error

A formula is pointing to a cell that no longer exists — usually because a row, column, or sheet it referenced was deleted.

#VALUE! — #VALUE! Error

The formula received the wrong type of data — commonly text where it expected a number.

#DIV/0! — #DIV/0! Error

The formula is dividing by zero or by an empty cell.

#N/A — #N/A Error

A lookup formula (VLOOKUP, MATCH, XLOOKUP, INDEX/MATCH) couldn't find a matching value.