Home → Troubleshooting → @RISK for Excel: Other Issues → Define Distributions and Browse Results Do Nothing

8.13. Define Distributions and Browse Results Do Nothing

Applies to: @RISK 5.x–7.x

A simulation seems to run normally, but when I click Browse Results nothing happens. Nothing happens when I click Define Distributions. When I try Fit Distributions, the initial fit dialog comes up, but when I click the Fit button on the dialog box I get this error:

Non-modal forms cannot be displayed in this host application from an ActiveX DLL, ActiveX Control, or Property Page.

First, determine whether you need a different article:

If Add Output and Define Correlations also fail to bring up windows, see Define Distributions, Add Output, and Define Correlations Do Nothing.
If you have release 7.5.0 or newer, and the results graph stays stuck at "Simulation is starting" after you start a simulation, see Define Distributions Does Nothing, Results Graph Stuck at "Simulation Starting".
If none of the buttons are active, see Toolbar Appears, But Every Button Does Nothing.

This problem has several possible causes, so you may have to try more than one solution.

Solution 1: Verify your installation of the Visual Basic 6 Runtime, and install the latest if yours is missing or out of date.

Solution 2: You may have an active add-in that is incompatible with @RISK. We list two we know of that give this result, but there could be others that we don't know about. So for a first pass, we recommend disabling all add-ins except those that are part of Excel.

The Laserfiche client software component called "Laserfiche Office Integration 8.3": A customer discovered that this contains Office plugins that prevent @RISK from bringing up some windows. Those plugins can't be disabled from within Excel, but that component must be uninstalled by using the Laserfiche installer. Other versions may or may not have this issue; only 8.3 is confirmed.
Morningstar Commodity: At least some versions appear to prevent the Define Distribution and Browse Results buttons from opening their windows.

(To list your active add-ins, click File » Options » Add-Ins. The active add-ins are the first list in the right-hand panel. Inactive add-ins, the second list, don't matter. To deactivate an add-in, without uninstalling it, notice the last column, which tells you whether it's an Excel add-in or a COM add-in. Then at the bottom, select that type in the drop-down box after the word "Manage", and click the Go button. After deactivating all add-ins, close and reopen Excel.)

Solution 3: A clean Uninstall and Reinstall of Palisade Software solves the problem in some cases.

Last edited: 2017-04-18

This page was: Helpful | Not Helpful