Home → Troubleshooting → @RISK for Excel: Other Issues → "This formula generates an error."
Applies to:
@RISK 6.x/7.x
I click Define Distributions, choose my distribution, and enter my parameters. The graph is displayed, and the Cell Formula box shows the formula. But when I click OK, I get
This formula generates an error.
Click Yes to correct, No to keep as is, Cancel to skip any edits.
How can the formula generate an error, when Define Distributions is able to graph it?
The trouble is not in your formula, but in the underpinnings of Windows and Excel. Here are the solutions we found for past customers with this problem. You may need to do more than one of these things to resolve the problem:
Add your Palisade folder as a trusted location, as follows: In Excel Options » Trust Center » Trust Center Settings » Trusted Locations, click "Add new location". Browse to the Palisade folder — usually C:\Program Files (x86)\Palisade or C:\Program Files\Palisade — select "Subfolders of this location are also trusted", and click OK.
Follow the procedure for Removing Outdated References to Office from the System Registry.
One of your other add-ins, or your personal macro workbook, may be conflicting with @RISK. Disable them all, and if that solves the problem then add them back one at a time to see which one(s) are causing trouble. For more detailed directions, see Find and Fix Startup Conflicts (Excel 2007–2016).
Last edited: 2018-05-10