HomeEnd User SetupConfiguring ExcelRecommended Option Settings for Excel

2.3. Recommended Option Settings for Excel

Applies to: All products, when used with Excel 2013 and 2016

Are there any special settings I need to make in Excel to use it with @RISK (BigPicture, Evolver, ...)?

In Excel 2007 or later, ensure that multi-threaded calculation is enabled.

Note: Though this is a global Excel option, it can also be changed by opening a workbook where the option was set differently. Check the status of the option while your particular workbook is open.

In addition, if you have Excel 2013 or 2016, and you have Palisade release 7.0.1 or earlier, you should disable the Excel start screen, as follows:

  1. Launch Excel. It doesn't matter whether you open a workbook or not.
  2. Click File » Options » General.
  3. Remove the check mark from the last option, "Show Start screen".
  4. Click OK and close Excel. (You must close Excel after clicking OK. After this, it will remember the setting.)

We recommend this because, if the Excel start screen is enabled, some add-ins may not load correctly. This can lead to intermittent errors at any point during your Excel session. By un-checking the option, you don't lose any functionality, since you can always click the File tab in the Excel menu.

See also: Getting Better Performance from Excel

Last edited: 2017-02-02

This page was: Helpful | Not Helpful