Home Products Enter Store Register Support

 

Frequently Asked Questions

RiskEase is not working with Excel 2007

"SOLVER.XLA could not be loaded" error message

What is the difference between "combining" and "comparing" multiple SRT's?

Using RiskEase files produced on another computer

Why do I lose some charts when I delete a SRT or a RVT?

How do I know which version of RiskEase I am using?

How to set links to external workbooks

RiskEase is not working properly with Excel 2007

RiskEase 1.x is compatible with versions of Excel up to and including Office 2003.  RiskEase 2 which is planned to be released in the 4th Quarter of 2007 will be compatible with Office 2007.  Registered users of RiskEase 1.x will be able to upgrade to RiskEase 2 when it is released at the upgrade price US$195.00.  Customers who order RiskEase 1.x from 1 May until the release date of RiskEase 2.0 will be able to upgrade to RiskEase 2.0 when released at the nominal price of US$45.00 plus shipping.

If you want to be using RiskEase 1.x after you buy Office 2007 it is advised to keep an older version of Excel installed on your computer until RiskEase 2 is released.

[ Back to Top ]

"SOLVER.XLA could not be loaded" error message

RiskEase makes use of Excel's Solver add-in for some of its functions,  such as fitting custom distributions to user data or performing simulations with optimization.  For these functions to be available, the Solver add-in must be included in the selected components when you install Excel (or Microsoft Office).  If you have not installed the Solver on your system, please run the Microsoft Office setup program again and select the option to install the Solver. For further details please consult Excel's online help (Topic: "Install and load Solver" in Excel 2000, "Install Solver" in Excel 97).

If you do not install the Solver then RiskEase will still run, but some functionality will not be available.

[ Back to Top ]

  What is the difference between "combining" and "comparing" multiple SRT's?

When you select the "Analyze Results" command, and provided that RiskEase detects two or more open  SRT's (Simulation Results Tables), it will give you the option either to "Compare results from different SRT's" or to "Merge multiple SRT's for combined analysis".  The first case is useful when you want to see the difference between the results for various simulation conditions (controlled by your RVT, Risk Variables Table inputs).  RiskEase will take the results from the selected SRT's and store them in a new one, so that you can then analyze them together.  This allows you, for example, to plot the same Model Result from two different scenarios on the same chart to establish any differences.  The option to combine SRT's is useful in Real Options analysis, where different possible scenarios are modelled as separate RVT's but must all be taken into account simultaneously.  RiskEase will combine the results from the selected SRT's into one column for each Model Result according to the weights that you specify, so that this constructed "Model Result" represents the weighted sum of all scenarios examined.

[ Back to Top ]

  Using RiskEase files produced on another computer

When you open a RVT (Risk Variables Table) or a model that was produced on another computer, Excel may produce a "File not found" dialog and ask you to locate the files RISKEASE.XLA or INVEST.XLA.  This happens even if RiskEase is already loaded because the opened file contains links to the location of the add-ins on the original computer.  In such cases just select "Cancel"; RiskEase will redirect the links automatically.

Please note that you may also get messages of the form

                "Microsoft Excel cannot find 'RVTbtnArrange' on 'RiskEase.xla'..."

when opening a RVT that was created on another computer.  This occurs for the same reason, namely that the RVT buttons still hold links to the copy of RiskEase that created that RVT.  Again, just click on Cancel to ignore the messages and RiskEase will automatically redirect all links as needed.  Save the RVT again to avoid getting these messages in the future.

[ Back to Top ]

  Why do I lose some charts when I delete a SRT or a RVT?

All charts created by RiskEase are produced using temporary worksheet areas to hold the displayed data.  When you select to save one of these charts, however, the data must also be saved to preserve the appearance of the chart.  Series data for sensitivity charts are stored in the corresponding RVT, while simulation result chart data are stored in the SRT that was analyzed to produce them.  When you delete these worksheets or if you move them to another location, the charts will contain external references that cannot be resolved by Excel and you may need to re-create them in RiskEase.

[ Back to Top ]

How do I know which version of RiskEase I am using?

To check which version of RiskEase you are currently using, start RiskEase and check the "About RiskEase" dialog from the RiskEase menu.

[ Back to Top ]

How to set links to external workbooks

To set up a RiskEase application with links to risk variables and model results made to external workbooks you should first open all the workbooks in a window format inside Excel.  To achieve this you should click on the double window icon at the top right corner of the Excel workspace.  You can then select each workbook when executing a "Set Links" or "Model results" operation.

  [ Back to Top ]

 

 

RiskEase and RiskMaster for Windows  are trademarks of Master Solutions Ltd.. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to webmaster@riskease.com.

Copyright 2000 Master Solutions Ltd. All rights reserved.