HomeEnd User SetupConfiguring ExcelOpening Palisade Software Automatically Whenever Excel Opens

2.7. Opening Palisade Software Automatically Whenever Excel Opens

Disponible en español: Apertura Del Software Palisade Automáticamente Cada vez que Inicia Excel
Disponível em português: Abrindo Software da Palisade junto com Excel

Applies to:
@RISK 5.x–7.x
Evolver 5.x–7.x
NeuralTools 5.x–7.x
PrecisionTree 5.x–7.x
RISKOptimizer 5.x only (For 6.x and newer, set @RISK to run automatically, not RISKOptimizer.)
StatTools 5.x–7.x
TopRank 5.x–7.x

There is never a requirement to add our add-ins or toolbars to Excel manually. Ordinarily, you open our software via a desktop shortcut if available, or through the start menu (All Programs or Programs and then Palisade DecisionTools). This can be done when Excel is already running, or when Excel is not running. If Excel is not running, our software will launch Excel automatically.

But some users prefer to double-click on workbooks (.XLS, .XLSX, .XLSM, etc.) to open Excel. In this case you must then start StatTools, @RISK, or our other software tools as a separate step. This article explains how to make any of our software tools open automatically, every time Excel opens. It's also possible to give this treatment to just one Excel workbook, if the workbook has macros enabled; see Setting References in Visual Basic.

Caution: If you plan on opening multiple instances of Excel, please do not configure our software to open automatically. Palisade software is not designed to run simultaneously in multiple instances of Excel, and you will get a message such as "Object initialized twice." (It's perfectly okay to have single instances of different Palisade applications running in the same instance of Excel, as long as they all have the same release number.)

Caution: A 5.x release, a 6.x release, and a 7.x release can coexist on the same computer, but they must not run at the same time. If you have one version starting automatically, don't run a different version until you first remove the first version from automatic startup.

For starting @RISK (Evolver, PrecisionTree, ...) automatically with Excel, please select your release below.

With releases 6.1–6.3 and 7.x:

  1. Launch the tool that you want to run automatically with Excel.

  2. In Excel 2010, 2013, or 2016, click File » Options » Add-Ins, then at the bottom of the page select "Manage Excel Add-Ins" and click Go.
    In Excel 2007, click the round Office button, then Excel Options, then Add-Ins, then at the bottom of the page select "Manage Excel Add-Ins" and click Go.
    In Excel 2003, with Palisade releases 6.x, click Tools » Add-Ins. (Excel 2003 is not compatible with Palisade releases 7.0 and newer.)

  3. You will see your currently running Palisade add-ins listed, along with any others that you have run previously. Put check mark(s) on the one(s) that you want to open automatically.
    Caution: Don't click the Browse button and go searching for add-ins; only the ones listed here are candidates.
    Exception: In 6.x/7.x, RISKOptimizer is part of @RISK. If you want RISKOptimizer to start every time Excel starts, tick the box for @RISK, not RISKOptimizer.

From now on, when Excel opens, the desired Palisade tool will open automatically with it. This applies when you double-click an Excel workbook or start Excel via a program shortcut.

If you change your mind later, go back to the Add-Ins list and uncheck the ones that you no longer want to load automatically. You will still be able to load them through the desktop icon or through the Windows Start button.

With release 6.0:

The above procedure will work for Evolver 6.0, NeuralTools 6.0, PrecisionTree 6.0, StatTools 6.0, and TopRank 6.0. However, it is not recommended for @RISK 6.0. @RISK 6.0 had a problem: If the @RISK or RISKOptimizer add-in is checked as described above, @RISK may crash at the end of a simulation that uses multiple CPUs. @RISK releases 6.1.1 and later do not have the problem.

With releases 5.5.1–5.7.1:

  1. Launch the tool that you want to run automatically with Excel.

  2. In Excel 2010 (no newer Excels), click File » Options » Add-Ins, then at the bottom of the page select "Manage Excel Add-Ins" and click Go.
    In Excel 2007, click the round Office button, then Excel Options, then Add-Ins, then at the bottom of the page select "Manage Excel Add-Ins" and click Go.
    In Excel 2003 or below, click Tools » Add-Ins.

  3. You will see your currently running Palisade add-ins listed, along with any others that you have run previously. Put check mark(s) on the one(s) that you want to open automatically.
    Caution: Don't click the Browse button and go searching for add-ins; only the ones listed here are candidates.

From now on, when Excel opens, the desired Palisade tool will open automatically with it. This applies when you double-click an Excel workbook or start Excel via a program shortcut.

If you change your mind later, go back to the Add-Ins list and uncheck the ones that you no longer want to load automatically. You will still be able to load them through the desktop icon or through the Windows Start button.

With release 5.0 or 5.5.0:

  1. Open just Excel (not @RISK).

  2. In Excel 2007, click the round Office button, then Excel Options, then Add-Ins, then at the bottom of the page select "Manage Excel Add-Ins" and click Go.
    In Excel 2003 or below, click Tools » Add-Ins.

  3. On the Add-Ins dialog, click Browse.

  4. In the window that opens, navigate to your @RISK installation folder. The most likely location is C:\Program Files\Palisade or C:\Program Files (x86)\Palisade, but it's possible that the Palisade software is installed elsewhere.

  5. Select the subfolder and double-click the add-in indicated in the table:

    To open this software automatically with ExcelSelect this folderDouble-click
    this file*
    And the add-ins list will show
    Evolver 5.0 or 5.5 Evolver5 Evolver.xla Evolver for Excel 5.0 or Evolver 5.5
    NeuralTools 5.0 or 5.5 NeuralTools5 NeuralTools.xla NeuralTools Add-In for Microsoft Excel or NeuralTools 5.5
    PrecisionTree 5.0 or 5.5 PrecisionTree5 PTree.xla PrecisionTree 2.0 or 5.5
    @RISK 5.0 or 5.5 RISK5 Risk.xla @RISK for Excel 5.0 or 5.5
    RISKOptimizer 5.0 or 5.5 RISKOptimizer5 RISKOpt.xla Evolver for Excel 5.0 or RISKOptimizer 5.5
    StatTools 5.0 or 5.5 StatTools5 StatTools.xla StatTools for Microsoft Excel or StatTools 5.5
    TopRank 5.0 or 5.5 TopRank5 TopRank.xla Toprank or TopRank 5.5
    *If you don't see the ".xla" file extension, choose the file with this name, right-click it, and select Properties. Verify that the type is Microsoft Office Excel Add-In, cancel the Properties dialog, and double-click the file.
  6. You are now back in the Add-Ins dialog, with a new entry checked, as shown in the last column of the table.

  7. If you wish, you can browse to additional Palisade add-ins to make multiple tools open automatically with Excel. (RISKOptimizer includes Evolver, so you can't open both of them automatically with Excel.) But add only the tools that you really do use almost every time you open Excel; otherwise you will just make Excel open slower for no good purpose.

  8. Click OK, then close Excel (File » Exit).

From now on, when Excel opens the desired Palisade tool will open automatically with it. This applies when you double-click an Excel workbook or start Excel via a program shortcut.

If you change your mind later, go back to the Add-Ins list and uncheck the add-in that you browsed to.

last edited: 2016-05-02

This page was: Helpful | Not Helpful