Fix Excel 'Not enough memory' error on copy-paste large datasets

Quick answer for advanced users

Clear the clipboard (Home > Clipboard > Clear All), then disable hardware graphics acceleration: File > Options > Advanced > Display > uncheck 'Disable hardware graphics acceleration'. If still failing, split your data into chunks under 10,000 rows and paste one chunk at a time.

Why this error happens

Excel's 'not enough memory' error on copy-paste is almost always a clipboard memory problem, not a RAM issue. When you copy a huge dataset — say 50,000 rows by 50 columns — Excel holds that entire range in a hidden clipboard buffer. If you're on 32-bit Excel (which still ships with Office 2019 and 2021), that buffer can max out the 2GB process memory limit fast. Even on 64-bit Excel, the clipboard's internal handling gets clumsy with very large selections.

I've seen this most often when someone copies from a pivot table or a sheet with conditional formatting formulas. The clipboard tries to replicate all that metadata, and boom — the error shows up. Don't bother restarting Excel or your PC first; that rarely helps unless you have a memory leak from a corrupt add-in.

Step-by-step fixes

Step 1: Clear the clipboard

Open Excel, go to Home tab, clipboard group, click the small arrow in the bottom-right corner to open the clipboard pane, then click 'Clear All'. This empties the hidden buffer. Also press Win + V on Windows 10/11 and click 'Clear all' there — that clears the system-wide clipboard history.

Step 2: Disable hardware graphics acceleration

This is the single most effective fix I've found. Go to File > Options > Advanced. Scroll down to the Display section. Check the box that says 'Disable hardware graphics acceleration'. Click OK and restart Excel. This forces Excel to use software rendering, which eliminates a whole class of memory errors tied to graphics driver conflicts.

Step 3: Copy in smaller batches

Select the first 10,000 rows of your dataset. Copy and paste. Then the next 10,000. Repeat. Excel handles smaller chunks better because the clipboard buffer stays small. If you're copying a million rows, split into 10-20 batches. Annoying? Yes. Works every time.

Step 4: Switch to 64-bit Excel

Check your Excel version: File > Account > About Excel. If it says 32-bit, you're capped at 2GB. Uninstall Office and reinstall the 64-bit version. This alone fixes memory issues for large datasets. Microsoft gives you both versions — pick 64-bit unless you need old 32-bit VBA controls or ActiveX plugins.

Step 5: Strip conditional formatting and formulas

Before copying, copy the range and paste it as values somewhere else. Then copy that plain data. Conditional formatting and array formulas bloat the clipboard. Use Home > Paste > Paste Special > Values to get rid of them.

Alternative fixes if the main ones fail

• Close other Office apps — Outlook, Word, and PowerPoint each hold clipboard locks. Close them all, then retry.
• Run Excel in Safe Mode: hold Ctrl while opening Excel, or run excel /safe from Run. If the error disappears, an add-in (usually a COM add-in or an old .xlam) is the culprit. Disable add-ins one by one.
• Increase virtual memory: On Windows, go to Advanced System Settings > Performance > Advanced > Virtual Memory. Set it to 1.5x your RAM size. Capped at 4GB for 32-bit Excel, but helps 64-bit.

Prevention tip for the future

Don't copy entire sheets. Use Ctrl + Shift + End to select only the used range. If you're regularly working with datasets over 100,000 rows, use Power Query (Get & Transform Data) to load data directly into the data model instead of the worksheet. That bypasses the clipboard entirely. Also — keep your Office updated. Microsoft patched several clipboard memory leaks in Excel 365 builds after 2021.

One last thing: if you're on a low-RAM machine (4GB or less), consider upgrading to 8GB. Excel alone can eat 2-3GB with a big workbook. But honestly, 90% of the time it's the clipboard or graphics acceleration.