When exporting to Microsoft Excel from Strategy Developer 9.x, users can configure the maximum RAM usage. This setting can be found at the project source level. Users can righ-mouse click on the project source and select the option "Modify Project Source", then select "Memory" tab as shown below:
Note: This property can be set to "-1", which means no memory limit.
The maximum value that can be set is 2047 MB.
This value is stored in the following registry key in the Desktop machine:
HKEY_LOCAL_MACHINE\SOFTWARE\Strategy\Data Sources\<Project_Source_Name>\Excel Memory Consumption
For 64 bit OS, it is stored here:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Strategy\Data Sources\<Project_Source_Name>\Excel Memory Consumption
