HomeTroubleshooting@RISK for Excel: Simulation"Out of Memory"

4.40. "Out of Memory"

Disponível em português: Sem memória

Applies to:
@RISK 5.x–7.x
@RISK for Excel 4.x
@RISK for Project 4.x
All other products (temp folder, virtual memory, and Windows desktop heap tips)

When I perform some operation, I get an "out of memory" error. What causes this, and what can I do about it?

Running programs often need more memory than you have in your computer. To meet this need, Windows uses disk space dynamically as "virtual memory", also called the "paging file". Many applications, including @RISK, also write files to your hard drive during operation. For instance, @RISK stores all simulation data in a temporary file for use when generating reports.

"Out of memory" can indicate an actual out of memory condition, or running out of resources such as disk space. Windows and your applications run better when your disk has elbow room — you can get "out of memory" long before you're down to the last megabyte of free disk space. "Out of memory" can also indicate that one or more worksheets in the workbook are protected.

The following apply only to @RISK. For instance, "Out of Memory" might appear when you open a simulation data window after a large simulation, or do something else that takes significant system resources.

Special note: Even if you're not getting the "out of memory" error, you may be able to speed up your @RISK simulation with the techniques in this article.

See also:

Last edited: 2017-02-15

This page was: Helpful | Not Helpful