Excel: "Cannot Complete This Task With Available Resources" / Not Enough Memory

You insert a column, sort a range, or open a big workbook and Excel stops with “Excel cannot complete this task with available resources. Choose less data or close other applications,” or “There isn’t enough memory to complete this action.” Your PC has 16 GB of RAM, so the message makes no sense.

Why: The error rarely means your computer is out of memory — it means the Excel process hit a ceiling. The biggest cause is 32-bit Excel: any 32-bit application is capped at about 2 GB of addressable memory regardless of how much RAM the machine has. Heavy workbooks (millions of formulas, thousands of shapes, sprawling PivotTables, or complex charts) burn through that 2 GB during recalculation. Add-ins and the default printer driver can pile on too.

Fix 1: Find out if you’re on 32-bit Excel — and move to 64-bit

This is the permanent fix for genuinely large files.

1. Check your version: File > Account > About Excel (or About Microsoft Excel). The top line ends in 32-bit or 64-bit.
2. If it says 32-bit and you routinely work with files near or above 2 GB of in-memory data, switch to 64-bit. 64-bit Excel can use all the physical RAM in the machine.
3. To switch: uninstall Office, then reinstall the 64-bit build from your Microsoft 365 / Office portal (during install choose the 64-bit option). Close other 32-bit Office add-ins first, since some won’t load in 64-bit.

If you can’t switch right now, the next fixes reduce what Excel has to hold in memory.

Fix 2: Slim down the workbook

Memory errors that strike on insert, sort, calculate, copy/paste, or open usually point at workbook bloat:

• Force a recalc check: A sheet with a million formulas recalculates everything when you insert one column. Convert finished results to static values where you can — copy the range, then Home > Paste > Paste Values — so they stop recalculating.
• Hunt down stray shapes: Press F5 > Special > Objects > OK to select every shape/object on the sheet. If hundreds light up (often invisible leftovers from pasted web data), delete them.
• Trim used range: If the scrollbar lets you scroll to row 900,000 on a small table, you have phantom formatting. Delete the empty rows/columns below and right of your data, then save.
• Simplify PivotTables and charts: Very large PivotTable caches and charts with tens of thousands of points are heavy. Reduce the source range or split across sheets.

Fix 3: Remove the add-in or printer driver that’s eating memory

1. Disable add-ins: File > Options > Add-ins, set Manage to COM Add-ins, click Go, clear all boxes, OK, restart Excel. Re-enable one at a time to find a leaky one.
2. Swap the default printer: Excel uses the default printer driver to render pages, and some drivers leak. Set Microsoft XPS Document Writer (or Microsoft Print to PDF) as the default temporarily via Settings > Bluetooth & devices > Printers & scanners, then retest.

Fix 4: Update Office and free up the machine

• Update Office: File > Account > Update Options > Update Now — out-of-date builds had real memory bugs.
• Close other apps / reboot: If the error clears after a reboot or after closing other programs, the machine itself was starved. A clean boot helps confirm a background app is the cause.

FAQ

I have tons of free RAM — how can Excel be “out of memory”? Because 32-bit Excel can only address ~2 GB no matter how much RAM exists. The machine isn’t full; the Excel process is.

Will 64-bit make my formulas faster? Not directly, but it removes the 2 GB wall so large models stop erroring out. Slow recalculation is a separate issue (convert finished results to values).

Could one specific file be the problem? Yes. If only one workbook triggers it, it’s almost certainly bloat — work through Fix 2 on that file.

Sources: Microsoft Learn — How to troubleshoot available resources errors in Excel