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: Excel may be short of process address space even when Windows has free RAM. Older or non-Large Address Aware 32-bit Excel builds have roughly 2 GB available. Updated 32-bit Excel 2013/2016 and Microsoft 365 use Large Address Aware (LAA) support, allowing up to 4 GB of address space on 64-bit Windows. Workbooks and in-process add-ins share that space, so complex models can still exhaust it. Physical RAM, other applications and drivers can also contribute.
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.
- Check your version: File > Account > About Excel (or About Microsoft Excel). The top line ends in 32-bit or 64-bit.
- If it says 32-bit, check the Office build and Windows architecture before assuming a 2 GB ceiling. For models that exceed the available 32-bit address space, 64-bit Excel can help; available RAM and system resources still limit it.
- 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
- 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.
- 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”? 32-bit Excel has limited address space shared with add-ins: roughly 2 GB in older/non-LAA builds, or up to 4 GB with LAA on 64-bit Windows. Free physical RAM does not remove that process limit.
Will 64-bit make my formulas faster? Not necessarily. It expands address space for large models, but does not guarantee faster recalculation or eliminate every resource error.
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
Additional sources: Microsoft — Large Address Aware Excel memory limits