Palisade Decision Tools Excel For Mac

Posted on by



Palisade's DecisionTools Suiteprovides a comprehensive decision and risk analysistoolkit to Microsoft®Excel®. Add the fully integrated power of Palisade’s leading risk and decision analysis products to Excel. The DecisionTools Suite combines seven products: @RISK for Excel, PrecisionTree, TopRank, NeuralTools, StatTools, Evolver, and RISKOptimizer for the most advanced analysis capability available today! Combine with Palisade’s Evolver or Excel’s Solver to optimize tough decisions and achieve your goals like no other Neural Networks package can. Works with Microsoft Excel Models Make Predictions with Incomplete Data Automatically Update Predictions when Data Changes.

Home → End User Setup → Configuring Excel → Opening Palisade Software Automatically Whenever Excel Opens

  • TreePlan helps you build a decision tree diagram in an Excel worksheet using dialog boxes. Decision trees are useful for analyzing sequential decision problems under uncertainty. TreePlan creates formulas for summing cash flows to obtain outcome values and for calculating rollback values to determine optimal strategy.
  • Top 3 Free Decision Tree Add-in for Excel! You can now easily create it in Excel that helps you research, analyze a financial, legal or business problem. An analysis tool will allow you to choose an optimal path by calculating the expected value of every strategy. Additionally, you can examine the uncertainty and risk associated with every.

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–8.x
Evolver 5.x–8.x
NeuralTools 5.x–8.x
PrecisionTree 5.x–8.x
RISKOptimizer 5.x only (For 6.x and newer, set @RISK to run automatically, not RISKOptimizer.)
StatTools 5.x–8.x
TopRank 5.x–8.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. It's also okay to open multiple workbooks, as opposed to multiple instances of Excel; see Using Excel During Simulation or Optimization for the difference.)

Caution: A 5.x release, a 6.x release, 7.x release, and an 8.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, 7.x, and 8.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/8.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:

Free excel for mac

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 FilesPalisade 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.5Evolver5Evolver.xlaEvolver for Excel 5.0 or Evolver 5.5
    NeuralTools 5.0 or 5.5NeuralTools5NeuralTools.xlaNeuralTools Add-In for Microsoft Excel or NeuralTools 5.5
    PrecisionTree 5.0 or 5.5PrecisionTree5PTree.xlaPrecisionTree 2.0 or 5.5
    @RISK 5.0 or 5.5RISK5Risk.xla@RISK for Excel 5.0 or 5.5
    RISKOptimizer 5.0 or 5.5RISKOptimizer5RISKOpt.xlaEvolver for Excel 5.0 or RISKOptimizer 5.5
    StatTools 5.0 or 5.5StatTools5StatTools.xlaStatTools for Microsoft Excel or StatTools 5.5
    TopRank 5.0 or 5.5TopRank5TopRank.xlaToprank 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: 2020-03-20

Home → End User Setup → Before You Install → Office 365 with Palisade Software

Palisade Decision Tools Excel For Mac Free

Disponible en español:Office 365 con el Software de Palisade

Palisade Decision Tools Excel For Mac

Applies to:
All products, releases 7.0.0 and newer

Can I use my Palisade software with Office 365?

Yes, if you have Palisade software 7.0.0 or a newer release AND you've installed Office 365 locally.

At this writing (October 2018), Office 365 is roughly equivalent to Office 2016 with additional feature updates, but sold on a subscription rather than as a one-time purchase. Thus the rule is the same as for Office 2016: the Palisade version must be 7.0.0 or newer, and Office must be a full local install on the same PC, laptop, or server with the Palisade end-user applications. (Mac users will need to use a Windows virtual machine; see @RISK on the Apple Mac.) If your Office is set up to be accessed through a Web browser or your phone, it's not compatible with Palisade software.

@RISK 7.0 and 7.5 may experience some problems with recent updates of Office 365 or Office 2019. In this case, the solution is to upgrade @RISK to the latest release.

Palisade excel

Palisade Decision Tools Excel For Mac Download

There's one way you can operate with Office and Palisade software in the cloud: install both (again, full Office install) on a terminal server, Citrix machine, or similar. In this setup, the Palisade software needs a Concurrent Network license. Please see @RISK in the Cloud.

I have Palisade software release 6.3.1, and my company has just rolled out Office 365.

Just like Office 2016, Office 365 is not compatible with Palisade software releases before 7.0.0. If you have an older Palisade release, you will need to upgrade it to our latest release. Please see Upgrading Palisade Software.

See also:

  • Update history for Office 365 ProPlus (listed by date) at Microsoft
  • Office 365: A guide to the updates at Computerworld, lists updates back to September 2015

Ut Palisade Decision Tools

Palisade tools for excel

Palisade Tools For Excel

For

Last edited: 2018-11-27