Share this article
Improve this guide
Runtime Error 7: Out of Memory [Fix]
Get rid of your temporary files to create space
5 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
Runtime error 7 out of memory is a common error every programmer faces at least once in a lifetime. Other computer users are also not exempt from this error, as it appeared when using Microsoft Excel.
You might get this error if you’re working on large projects using too much memory. A run repair tool should suffice, but even such requires memory to be installed, which is a memory issue. If a repair tool is out of the picture, find other ways to deal with this error.
What is the run time error 7 in Excel?
Run time error 7 is common in Excel. It occurs when the program runs out of memory. This can happen if you work with a large spreadsheet or have many spreadsheets open simultaneously.
It may also occur when you try to run a macro you have written, but when you execute it, it fails because your system lacks sufficient resources.
Other reasons you may encounter the runtime error 7 out of memory include:
Strangely enough, one of our readers encountered this error when one of the cells in the spreadsheet had an apostrophe (King’s Lynn). Removing the character returned everything to normal.
How can I fix the runtime error 7 out of memory?
Start off with these basic workarounds before jumping onto the heavy hitters:
1. Defragment your hard disk drive
2. Increase Virtual Memory
Should the above steps fail to yield the expected results for runtime error 7 out of memory, upgrading your RAM would be next.
But before you’re quick to get a new one, do your due diligence first. Sometimes, you may find thatWindows is not using all RAMor even with two RAM sticks,only one RAM slot is working.
Exhaust all avenues before replacing any components of your PC. We all know nothing comes cheap.
That’s it for this article, but if you have any other solution worth mentioning, let us know in the comment section below.
More about the topics:Microsoft Excel,Runtime Errors
Claire Moraa
Windows Software Expert
Claire has a knack for solving problems and improving the quality of life for those around her. She’s driven by rationality, curiosity, and simplicity, and always eager to learn more about Microsoft’s products. With a background in teaching and reviewing, she breaks down complex topics into easily understandable articles, focusing mostly on Windows 11, errors, and software.
User forum
1 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Claire Moraa
Windows Software Expert
With a background in teaching and reviewing, she breaks down complex topics into easily understandable articles, focusing mostly on Windows 11 errors.
