Fix Excel Cannot Insert or Delete Rows Due to Memory Error
Question details
The user is unable to insert or delete rows and columns in Microsoft Excel because the application displays an insufficient memory error, despite the computer having ample available RAM.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to modify the structure of a spreadsheet by inserting or deleting rows or columns.
- Observed behavior
- Excel blocks the action and reports an insufficient memory or resource error, which is often caused by corrupted temporary files or workbook-specific issues.
Before clearing any application data folders, ensure you have saved your current work and completely closed all running instances of Microsoft Excel.
Clear Excel AppData and Temporary Folders
Clearing Excel's temporary files and roaming data can resolve false memory errors caused by a corrupted application cache.
Excel relies on temporary data folders to manage clipboard and background operations. When these files become bloated or corrupted, Excel may misreport system resources and display memory errors even when sufficient RAM is available.
Save your active workbooks and exit Microsoft Excel completely to ensure the temporary files are not currently in use.
Press the Windows Key + E on your keyboard to open a new File Explorer window.
Navigate to the path C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel and delete all files and folders located inside it.
Next, navigate to C:\Users\[YourUsername]\AppData\Local\Temp\ASPWebView. If this folder exists, delete all of its contents.
Relaunch Excel, open your original workbook, and attempt to insert or delete rows to verify the memory error is resolved.
Check for Workbook-Specific Issues
Sometimes the memory error is tied to a specific corrupted workbook rather than the Excel application itself.
Switch to WPS Spreadsheet to Avoid Excel Memory Errors
If Microsoft Excel keeps crashing or showing false memory errors, try WPS Office. It is a highly compatible, free, and lightweight alternative that easily handles large datasets without exhausting your system resources.
- 1. Download the Installer: Visit the official WPS website and download the free WPS Office installation file.
- 2. Install WPS Office: Run the installer and follow the quick on-screen prompts to set up the software on your computer.
- 3. Open Your Workbook: Right-click your existing .xlsx file, select 'Open with', and choose WPS Spreadsheet to effortlessly insert and delete rows without memory limitations.
Frequently Asked Questions
Why does Excel say not enough memory when I have plenty of RAM?
This error is typically caused by corrupted temporary application files, excessive formatting applied to entire columns, or limitations of the 32-bit version of Excel, which cannot utilize more than 2GB of memory regardless of how much physical RAM your computer has.
How do I find the AppData folder if it is missing from my user folder?
The AppData folder is hidden by default in Windows operating systems. To view it, open File Explorer, select the 'View' tab at the top of the window, and check the box labeled 'Hidden items'.
Will deleting the Microsoft Excel AppData folder delete my saved spreadsheets?
No. Clearing the roaming Excel folder only removes temporary configurations, cached files, and customized interface settings. Your personal workbooks and saved .xlsx files are stored separately (usually in Documents or OneDrive) and will not be affected.
How can I prevent Excel memory errors from happening in the future?
To prevent recurring memory errors, keep your Microsoft Office suite updated, upgrade to the 64-bit version of Office if you handle large datasets, routinely clear your temporary AppData folders, and avoid applying cell formatting to entire rows or columns unnecessarily.
