Originally from ticket #47701.
I have recently installed Excel 2013 and have reinstalled Analytic Solver Platform. In cells where I have "=PsiNormal(5%,10%)" formulas I now see the message #NAME? instead of a random variable. When I run the simulations I see the same message.
As a quick check, open the Function Wizard in Excel (click the fx icon), then open the dropdown list of function categories. If you don't see PSI Distribution, PSI Statistics, etc. in the list, this means the add-in functions are not enabled.
On the File tab, click Options, then in the left column of the dialog box, click Add-Ins. You should see both 'Analytic Solver Platform' Excel Add-In and "Analytic Solver Platform Addin' COM Add-In in the list. The PSI functions are defined by the Excel Add-In.
At the bottom of the dialog, you should see, or be able to select from the dropdown list, Manage Excel Add-Ins -- then click the Go button. This opens another dialog with a list of add-ins. You should see Analytic Solver Platform in the list -- make sure the box is checked next to it (click the box to check or uncheck). Then click the OK button.
Now go back to the Home tab. If the #NAMEs don't disappear immediately, just close and reopen the workbook. You should see a numeric sample value instead of #NAME.