search

pyscripter / XLRisk

Excell addin for performing Monte Carlo simulation
MIT License
112 stars 24 forks source link

Excel crash when generating the reports #2

Closed APL78 closed 1 year ago

APL78 commented 4 years ago

First of all thanks for this excel Add-in. Very simple, very useful ! Here is the issue. when there is a lot of risk functions and a lot of iterations, Excel (MacOS version 16.34) crashes at the reports creation's step (ProduceCumulativeDistributions, ...), more precisely when creating the charts.

I had a look on Internet and found this: https://stackoverflow.com/questions/36232382/initializing-chart-object-in-crashes-vba .

So I inserted R.Select before each Set NewChart = mOutSheet... instruction and now it works fine for me.

Cheers

pyscripter commented 4 years ago

First of all thanks for this excel Add-in. Very simple, very useful !

Then please star the project. It will give greater visibility!

Are you using the latest version of XLRisk. I thought that this addresses your issue. Please try the latest version and report back whether the issue still exists.

pyscripter commented 1 year ago

Should be fixed with the last couple of commits. Please test again.