Excel crah when i Run the simulation

[Lash1991]

[pyscripter]

Please provide extra information:

• Version of Excel Used.
• Attach a minimal Excel model (or a download link to the model) that reproduces the error.

[Lash1991]

I am using MS 365 PRO and I am using the example file in the wiki section of the site "NOVA.xlsx" Excel crashes every time I try to run the simulation. the functions is working right but when I try to run the simulation it crashes and restarts excel.

Thanks for your support

[pyscripter]

I cannot reproduce it here on Windows Microsoft® Excel® for Microsoft 365 MSO (Version 2409 Build 16.0.18025.20030) 64-bit , Could you please post your model saved just before running the simulation?

[Lash1991]

this is my excel version Microsoft® Excel® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit Nova.xlsx

[pyscripter]

I added the NPV and IRR as outputs, as explained in the tutorial, then press the Run button. Everything works as expected. Not sure what the problem is on your side.

If you

• start Excel
• In empty workbook type =RiskNormal(100,20) on A1.
• Add A1 as output calling it "Normal"
• Press the Run button.

Do you still get the crash?

Did you follow the installation instructions? In particular step 3 (Trust center).

[Lash1991]

unfortunately, it crashed again and yes I followed the installation instructions

[pyscripter]

I don't know how to help. Can you update you Excel to a more recent version to see whether this helps?

[Lash1991]

yes, i will do thanks