Applies to: All products

Background:

The DTS installer automatically detects 32-bit Excel or 64-bit Excel and can install DTS with either version.

32-bit Excel vs. 64-bit Excel

In most situations, you will not get better performance with 64-bit Excel.

• If you work with large simulations in @RISK (or the other DTS Tools), more than 2 GB of data, you may benefit from it.
• Some features of our software releases 7.6 will run faster in 32-bit Excel, because they normally run in process. 
• This is especially noticeable in simulations involving Microsoft Project.

64-bit Office is recommended when you have gigabytes of data and you have enough physical memory to store it, because then the data can all be held in RAM without being paged out to disk. 

• There is no speed improvement from 64-bit code as such, only from holding data in RAM and not paging it out to disk.
• If your data size is under 2 GB, you can more easily hold all data in RAM by simply not running other memory-hungry applications at the same time.

By default Office installs itself as a 32-bit application, even in 64-bit Windows.

Large Address Aware

In June 2016, Microsoft released a Large Address Aware update to Excel 2013 and 2016, which changed the 2 GB limit on address space.

Many features of @RISK and our other software were Large Address Aware in release 7.5.1

All features are Large Address Aware in 7.5.2 and Up.

With this update installed, 32-bit Excel in 64-bit Windows will automatically be able to use a 4 GB address space.

• If you have 32-bit Excel 2013 or 2016 in 64-bit Windows, and if your model needs more than 2 GB but less than 4 GB, getting this update is a much simpler solution than installing 64-bit Excel.
• Please read the Large Address Aware article carefully before you set the option in your boot file - it may cause other system issues.

 

Related Articles:

Memory Used by @RISK Simulations

Running "Out of Process"

DTS software works with 64-bit Excel