I've made a workbook which uses previously generated strings of random numbers to produce normal distributedf und performance returns based on a specified std dev and mean - this gives me a stochastic run of performance every month for 120 years. Annual Fees are then calculated from these returns and charts are produced of these fees. In order to show the 'average' fees for a given return/std dev and fee structure, I basically run the sheet 250 times and each time output a value onto a worksheet, then chart from this range. I also produce a fee surface for defined volatilities and returns (there are 600 points on this surface, each an average of 30 stochastic runs). When I time how long the sheets take to calculate, I get the following (for 100 runs)

Front 0.03125
Generated Performance 0.046875
Data 0.375
Complex Fee Data 0.03125
Fee Runs 0.1875

And when I F9, the workbook recalculates quickly. But when I run my macros to produce the monte-carlo outputs, it takes ages!. For example, here is my code for the 'average' performance at a given return/std dev:

Please Login or Register  to view this content.
Given this code only requires recalculating 250 times why does this take 5 minutes?

And my code ofr the fee surface:

Please Login or Register  to view this content.
Can I make this faster by changing my code? Or is the issue in my formulae?

Thanks!