FAQ - Troubleshooting

Download a pdf copy of this help file  here

See also: ModelRisk functions and windows, List of all ModelRisk functions, Graphics, workflow and error handling in ModelRisk

What follows is a list of known issues and problems with ModelRisk and their solution.

For up to date help and answers to your questions, please refer to the ModelRisk support section on our website.

Should that not work, please fill in the feedback form on our web site and we will follow up to you as soon as possible.

ModelRisk is not loaded when I start Excel

This can be caused by Excel disabling the ModelRisk add-in, because it was not shut down properly after the previous session. Try following these steps:

Excel 2007

1. Click the Office button and then Excel Options.

2. Go to the Add-Ins section.

3. From the Manage drop-down menu, select Disabled items and then click the Go button.

4. From the list, select Addin:ModelRisk and then click the Enable button.

Now when you restart Excel/ModelRisk, the problem should be solved.

Excel 2003 and earlier

1. Click the help menu and then choose About Microsoft Excel.

2. Click the Disabled Items button.

3. Select ModelRisk from the list and press the Enable button.

Now when you restart Excel/ModelRisk, the problem should be solved.

Example models open within this help file window and not in Excel

(instructions for Windows XP)

1. Open Windows Explorer by right-clicking the Windows start button and selecting Explore from the menu.

2. Select Folder Options... from the Tools menu.

3. The Folder Options dialog opens. Select the File types tab.

4. From the list of Registered file types, locate and select XLS - Microsoft Excel Worksheet:

5. Click the Advanced button.

6. In the Edit file type dialog that appears, make sure Browse in same window is NOT marked:

7. Click OK to close this window. Now when you click a link to an example model in this help file, it should open in Excel.

Modeling

Why do I get a #VALUE! in a cell with a ModelRisk function?

ModelRisk functions return error messages when the parameters are incorrect. For example, VoseNormal(mu,sigma) generates random samples from a Normal distribution with mean mu and standard deviation sigma. However, if one inputs a negative value for sigma, the function returns the error message:

“Error: sigma must be >= 0”

If the formula in a cell includes this function in a calculation, Excel is unable to evaluate the formula and displays #VALUE!. For example, you will get #VALUE! in a cell containing the formula:

=10 + VoseNormal(100, -10)

You can easily see whether this is the reason for the error display using Excel’s Evaluate Formula feature, in the Formula ribbon or toolbar:

Clicking the Evaluate button displays the problem:

Alternatively, using ModelRisk’s View Function tool you will see the error message displayed.