Applies to:
@RISK 6.x and Up

Define Distributions Error:

"This formula generates an error.
Click Yes to correct, No to keep as is, Cancel to skip any edits."

 

Cause:

The issue does not stem from your formula but from underlying Windows or Excel configuration. 

Solutions:

1. Add the Palisade folder as a trusted location:

   1. Go to Excel Options → Trust Center → Trust Center Settings → Trusted Locations.

   2. Click Add new location.

   3. Browse to the Palisade installation folder (typically C:\Program Files (x86)\Palisade or C:\Program Files\Palisade).

   4. Select “Subfolders of this location are also trusted”, then click OK.

   5. Follow the procedure for Removing Outdated References to Office from the System Registry.

2. An Excel add-in or a macro workbook may be conflicting with @RISK. 

   1. Disable any Excel addins, and if that solves the problem then add them back one at a time to see which one(s) are causing trouble.

      1. For more detailed directions, see Find and Fix Startup Conflicts (Excel 2007–2016).